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

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 table