This discussion is archived
1 Reply Latest reply: Sep 3, 2010 11:16 AM by Ranganathan RSS

Displaying output as a single column.

714287 Newbie
Currently Being Moderated
Hi,

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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points