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
At 10:56 AM 6/24/04, Matthias Kritz wrote:
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
://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 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
:
Fax to:
06/24/2004 01:33 Subject: RE: JOIN or UNION or both