Matthias, > 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
We still don't know which version you're using, but have a look at http://www.codeproject.com/Purgatory/mygroupconcat.asp It worked for me (MySQL 4.0.x) HTH, Markus ----- Original Message ----- From: "Matthias Kritz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 24, 2004 7:33 PM Subject: RE: JOIN or UNION or both? > 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] > > ---------------------------------------- My Inbox is protected by SPAMfighter 933 spam mails have been blocked so far. Download free www.spamfighter.com today! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
