LEFT JOIN > -----Original Message----- > From: Leif K-Brooks [mailto:eurleif@buyer-brokerage.com] > Sent: Wednesday, October 30, 2002 9:49 PM > To: php-db@lists.php.net > Subject: Multiple table select, but still returning row if no > record exists in second table? > > 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
