RE: JOIN or UNION or both?

2004-06-24 Thread SGreen
<[EMAIL PROTECTED]> x.net> cc: Fax to:

Re: JOIN or UNION or both?

2004-06-24 Thread Markus Grossrieder
p 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.

RE: JOIN or UNION or both?

2004-06-24 Thread Matthias Kritz
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 a

Re: JOIN or UNION or both?

2004-06-24 Thread Frank Bax
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

Re: JOIN or UNION or both?

2004-06-24 Thread SGreen
x.net> cc: Fax to: 06/24/2004 10:56 Subj

JOIN or UNION or both?

2004-06-24 Thread Matthias Kritz
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' n