[snip] If you have MySQL 4, you can use a UNION. Otherwise you'll need a second table, because what you want is not a join, but a concatenation of result sets. [snip]
Don't have 4.0 yet, probably going to wait until a production release comes out. So if I need a second table I will have to do that...trying to keep one query statement per PHP request. Thanks! Jay --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
