check two tables at same time?

hey guys, im trying to figure out a query that i can return rows from more than one table at a time. for example, i have two identical tables in structure and i want to return rows from both using one query. maybe this will help: select * from table1 and table2 where condition='value' is there any way to do this? thanks! - Noah ---------------------------------- TradeMyTraffic! Web Services http://www.trademytraffic.com