[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.
You might be able to use a merge table, but it will require a query to create it. That query could be done earlier, though, if the number of combinations of tables is small. [/snip] Do you know if there is a limit on table size with MERGE? 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