Re: Query Help - Thanks

2004-02-29 Thread Michael Stassen
I'd like to add an alternate solution. All these subselects and unions seem overly complicated to me, when you could accomplish the same thing with a single join. Also, union requires mysql 4.0.x or higher and subselects require mysql 4.1 or higher. (Of course, you are obviously using 4.1+ s

RE: Query Help - Thanks

2004-02-29 Thread John Berman
Rhino This is great it works a treat Thanks Regards John Berman -Original Message- From: Rhino [mailto:[EMAIL PROTECTED] Sent: 29 February 2004 13:40 To: [EMAIL PROTECTED]; 'Paul DuBois' Cc: [EMAIL PROTECTED] Subject: Re: Query Help I hope you don't mind me butting in but your note w