1 Reply Latest reply: Sep 3, 2010 1:16 PM by Ranganathan RSS

    Displaying output as a single column.


      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?