Re: SQL for spreadsheet output

From: Luis <andyza_at_webmail.co.za>
Date: 28 Jul 2004 09:36:18 -0700
Message-ID: <69476b6f.0407280836.35dfdb90@posting.google.com>

"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