[PHP-DB] Multiple table select, but still returning row if no record exists in second table? From: Leif K-Brooks (eurleif <email protected>)
Date: 10/30/02

I'm using mysql. Is there any way to do a multiple-table select, but
still return the results from table 1 if there are no matching rows in
table 2? Something like "select table1.something,table2.something as
something2 from table1,table2 where table1.table2id = table2.id" will
only return the data from table1 if a row with the id in table1.table2id
exists in table2. 

-- 
The above message is encrypted with double rot13 encoding.  Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php