Re: [SQL] query tables based on a query

2005-10-24 Thread Bruno Wolff III
On Fri, Sep 30, 2005 at 18:47:48 -0400, solarsail <[EMAIL PROTECTED]> wrote: > I have a large number of tables with a common naming convention > > basically: > > table001, table002, table003 ... table00n > > > I would like to do a query across all of the tables, however I do not know > all of

[SQL] query tables based on a query

2005-10-04 Thread solarsail
I have a large number of tables with a common naming convention basically:       table001, table002, table003 ... table00n I would like to do a query across all of the tables, however I do not know all of the tables before hand, and I do not want to manually generate a query like select *