Multiple table select, but still returning row if no record exists in second table?
| From: | Leif K-Brooks | Date: | Thu, 31 Oct 2002 02:48:57 +0000 |
| Subject: | Multiple table select, but still returning row if no record exists in second table? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22835@lists.php.net to get a copy of this message | ||
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.