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

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 * fro