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
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