The query should look similar to this:
SELECT table1.col as [column_a],
table2.col as [column_b]
FROMtable1
LEFT JOIN (or LEFT OUTER JOIN) table2
ON table2.some_key_col = table1.some_key_col ... for all required keys
WHERE
--
PHP Database Mailing List (http://www.php.net/)
To
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visi
LEFT JOIN
> -Original Message-
> From: Leif K-Brooks [mailto:eurleif@;buyer-brokerage.com]
> Sent: Wednesday, October 30, 2002 9:49 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Multiple table select, but still returning row if no
> record exists in second table?
>
> I'm using mysql. Is