RE: [PHP-DB] Multiple table select, but still returning row if no record exists in second table?
| From: | phplists at cyrusburz dot com | Date: | Thu, 31 Oct 2002 21:38:16 +0000 |
| Subject: | RE: [PHP-DB] 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-22865@lists.php.net to get a copy of this message | ||
The query should look similar to this:
SELECT table1.col as [column_a],
table2.col as [column_b]
FROM table1
LEFT JOIN (or LEFT OUTER JOIN) table2
ON table2.some_key_col = table1.some_key_col ... for all required keysWHERE <search condition>