[PHP-DB] check two tables at same time?

2002-06-24 Thread Noah Spitzer-Williams
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'

Re: [PHP-DB] check two tables at same time?

2002-06-24 Thread szii
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

Re: [PHP-DB] check two tables at same time?

2002-06-24 Thread Noah Spitzer-Williams
4b1fdb20$[EMAIL PROTECTED]... 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,