At 12:08 -0500 9/23/02, Paul DuBois wrote: >At 9:55 -0700 9/23/02, neal wrote: >>Thanks for the suggestion but this would actually create a new table, >>correct (the first statement that is)? I just want a resultset with these >>values, without writing to disk. > >Then you must upgrade to 4.x so that you have UNION support. >Either that, or write a client program that issues multiple SELECT >statements and buffers the results in memory.
I forgot another possibility. *IF* your tables all have identical structure and they are MyISAM tables, you can create a MERGE table from them and query the MERGE table. This will select from all the constituent MyISAM tables at once. identical = all columns and indexes the same --------------------------------------------------------------------- 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