access two like tables with one query

[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 query to get all the rows related to port 
from both files without creating a merge table?

thanks
- hcir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]