Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL for spreadsheet output
"André Hartmann" <andrehartmann_at_hotmail.com> wrote in article
<41013262$1_at_olaf.komtel.net> :
>> How do I structure my sql statement so that I get this result?
>
> You probably want more than one student in a course and more than one
>course for a student. so probably you want a many-many relationship between
>TblStudent and TblCourse. You might want:
<snip>
Using your example as a model I managed to get it working! Thanks!
I'd like to explore this further, but I'll do it in a new post...
Thanks again. Received on Wed Jul 28 2004 - 11:36:18 CDT