List:General Discussion« Previous MessageNext Message »
From:Markus Grossrieder Date:June 24 2004 6:04pm
Subject:Re: JOIN or UNION or both?
View as plain text  
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" <matthiaskritz@stripped>
To: <mysql@stripped>
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: SGreen@stripped [mailto:SGreen@stripped]
> > Sent: Donnerstag, 24. Juni 2004 17:25
> > To: Matthias Kritz
> > Cc: mysql@stripped
> > 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"
> >
> >                       <matthiaskritz@gm        To:
> > <mysql@stripped>
> >                       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?> unsub=sgreen@stripped
> >
> >
> >
> >
> >
> >
> >
> >
> > -- 
> > MySQL General Mailing
> > List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?> unsub=matthiaskritz@stripped
> >
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
>
>

----------------------------------------
My Inbox is protected by SPAMfighter
933 spam mails have been blocked so far.
Download free www.spamfighter.com today!

Thread
JOIN or UNION or both?Matthias Kritz24 Jun
  • Re: JOIN or UNION or both?Frank Bax24 Jun
Re: JOIN or UNION or both?SGreen24 Jun
  • RE: JOIN or UNION or both?Matthias Kritz24 Jun
    • Re: JOIN or UNION or both?Markus Grossrieder24 Jun
RE: JOIN or UNION or both?SGreen24 Jun