RE: Multiple table select, but still returning row if no record exists in second table?

[phplists@cyrusburz.com]

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 keys
WHERE <search condition> 


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