----- Original Message ----- From: "Bruce Feist" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Saturday, June 28, 2003 6:28 PM Subject: Re: Advanced Query Help (My brain hurts!)
> otherguy wrote: > > > That gets me halfway there > > Does it? Yes, it does. >In your original question, you'd indicated that you only > wanted zips where *both* criteria were met -- enough CIRGs and enough > CILTs. By using a UNION, you'll be getting zips where *either* is met. No. The key is that each independent query was returing the results he wanted - so, the UNION statement will simple append these two results into one long dataset - the WHERE clause, criteria, or even the number of records is really not affected. Thanks, Dennis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
