Hi,
I have the following table structure:
tbl_speakers
sid
fname
lname
tbl_presentations
pid
name
desc
tbl_speakers_presentations
sid
pid
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
SELECT *
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
SQL :-)
Any help is greatly appreciated!
Thank you,
Matthias Kritz
_____________________
Digital Samba, S.L.
http://www.digitalsamba.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
