Showing multiple lines of data on same line

[ja01]

Here is my situation. I have a script
select schoollookup, degree, schoolname from
school left outer join degrees degr where degr.table_code=degree

Output:
If a person has 2 degrees, the first degree will be schoollookup 1 and the second will be schoollookup2. They will display veritically (schoolllookup 1 will be on top). I want to display the data horizontally in a spreadsheet display. In other words, schoolookup1 will be on the left of schoolllokup 2 if any. What revision can I make to the script to accomplish this.

 

[jbenson001]

This is a job for your front end app, not SQL.

 

[monksnake]

I don't understand that query

select schoollookup, degree, schoolname from
school  left outer join degrees degr where degr.table_code=degree

Isn't this equivalent to this:

select schoollookup, degree, schoolname from
school

??


<.