Shawn, Thank you for your reply. That would have been an elegant solution but unfotunately Im not running 4.1 yet, which is required for GROUP_CONCAT() (no chance of an upgrade either).
Is there a possibility of running perhaps two queries, one nested within the other? This way I could pull out 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, S.L. http://www.digitalsamba.com > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Donnerstag, 24. Juni 2004 17:25 > To: Matthias Kritz > Cc: [EMAIL PROTECTED] > Subject: Re: JOIN or UNION or both? > > > > Have you looked at the GROUP_CONCAT() function? > > http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html > > It returns a string result with the concatenated values from > a group. If you didn't do this you would end up with a > ragged-right data set that is just a nightmare to manage with > SQL. In one row you would get 2 columns of data, in another > you could have 10. This way you end up with two columns, one > of them is a list of values. > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > > > > > "Matthias Kritz" > > <[EMAIL PROTECTED] To: > <[EMAIL PROTECTED]> > x.net> cc: > > Fax to: > > 06/24/2004 10:56 Subject: JOIN > or UNION or both? > AM > > > > > > > > > > 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/mysql?> [EMAIL PROTECTED] > > > > > > > > > -- > MySQL General Mailing > List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
