I have a strange problem, I need to display the output of 2 columns as a single column. Is it possible?
I have 2 columns in a table first_name and last_name , I want to combine the output and show the output as a combination of both the first_name and last_name as a supervisor -
The query is as follows:
select first_name,last_name as supervisors from PERSONS, person_sups where persons.person_id = person_sups.person_id;
I want both fisrt-name and last_name to appear as supervisors. Is this possible?