RE: JOIN or UNION or both?

2004-06-24 Thread Matthias Kritz
all presentation info first, and then the relating speaker info (with a php loop through the recordset)? Or could I do this with a temp table? I dont know the in's and out's, so any help is greatly appreciated! Thank you, Matthias Kritz _ Digital Samba,

JOIN or UNION or both?

2004-06-24 Thread Matthias Kritz
akers, 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