Have you looked at the GROUP_CONCAT() function?
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.
Unimin Corporation - Spruce Pine
<matthiaskritz@gm To: <mysql@stripped>
06/24/2004 10:56 Subject: JOIN or UNION or both?
I have the following table structure:
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
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
Any help is greatly appreciated!
Digital Samba, S.L.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1