I have the following table structure:
I would like to display all presentations, (but each only once), and
display the speakers' names for each presentation. With my current
syntax (see below), if a presentation has, say, 3 speakers I receive 3
distinct records - I just want 1 with 3 speakers columns.
//PULL OUT EVERY PRESENTATION WITH A SPEAKER AS SEPERATE RECORD
FROM tbl_presentations, tbl_speakers, tbl_speakers_presentations
WHERE tbl_speakers.sid = tbl_speakers_presentations.sid
AND tbl_presentations.pid = tbl_speakers_presentations.pid
I cant figure out the right JOIN or UNION or AS syntax - still learning
Any help is greatly appreciated!
Digital Samba, S.L.