SQL JOINs... http://www.mysql.com/doc/J/O/JOIN.html
-Mike ----- Original Message ----- From: "Noah Spitzer-Williams" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 24, 2002 4:21 PM Subject: [PHP-DB] 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 > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
