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

2002-06-24 Thread Noah Spitzer-Williams
ot;>news:006601c21bd8$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: Mon

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, > &

[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' i