Re: access two like tables with one query

2005-03-03 Thread SGreen
Rich Allen <[EMAIL PROTECTED]> wrote on 03/03/2005 04:28:07 PM: > iH > > i have a database that i only have READ access to (i am not the > creator). there are tables with stats data that are created each day; > ie "data3_1_2005" and 'data3_2_2005". each table has the same layout. > > create ta

access two like tables with one query

2005-03-03 Thread Rich Allen
iH i have a database that i only have READ access to (i am not the creator). there are tables with stats data that are created each day; ie "data3_1_2005" and 'data3_2_2005". each table has the same layout. create table data3_1_2005 ( port char(8), tmval int, val int ) how can i create a single