How can I select in multi table

2001-12-26 Thread cbsly
In my catalogs, there are many tables with the same structure. Every table is very large, several million records and about 1 GB size. It is impossible to merge them into single one. How can I select in all of them at the same time but not select * from table1 where ... then select * from

Re: How can I select in multi table

2001-12-26 Thread Michael Brunson
On Thu, 27 Dec 2001 11:19:18 +0800, cbsly [EMAIL PROTECTED] wrote: | In my catalogs, there are many tables with the same structure. Every table is very |large, several | million records and about 1 GB size. It is impossible to merge them into single one. | How can I select in all of them at the