Displaying row values horizontally

NeeluJoshi · New User Joined: 12 Dec 2007 Posts: 8 Location: Florida

Hi,

I have two tables

Student(Studentid,studentname)
Course(studentid, courseid)

For one student id there can be many courseids

I want to join these two tables and display the results like
Studentid1 courseid1 courseid2 courseid3
Studentid2 courseid3 courseid4

Can anyone help me on this.

stodolas · Posted: Tue Feb 05, 2008 3:28 am

Impossible with a single query.

stodolas · Posted: Tue Feb 05, 2008 3:29 am

The biggest limitation is that the number of courses per student varies and you need to select all the return fields in the ... of the the SELECT ... FROM statement.

khamarutheen · Active Member Joined: 23 Aug 2005 Posts: 677 Location: NJ

I dont think it 's possible

rag swain · Posted: Tue Feb 05, 2008 9:07 pm

Can you show some data from both the tables? Are there other columns related to course_id in COURSE table

stodolas · Posted: Tue Feb 05, 2008 9:14 pm

You need to do this in a post processing program.

The O/P gave the format of the original data. You can come up with your own dataset based on what they gave.

Here, I'll give you one.

rag swain · Posted: Tue Feb 05, 2008 9:49 pm

Why not thru a program? Is this a real time scenario/request ,OR, just out of curiosity ,OR, are you trying to generate a formatted report as part of adhoc request thru QMF? Crazy one without program!