 |
 |
 |
 |
|
|
Date: 10/31/02
- Next message: Michael Conway: "[PHP-DB] Restarting Mysql"
- Previous message: phplists <email protected>: "RE: [PHP-DB] Multiple table select, but still returning row if no record exists in second table?"
- Maybe in reply to: Leif K-Brooks: "[PHP-DB] Multiple table select, but still returning row if no record exists in second table?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Next message: Michael Conway: "[PHP-DB] Restarting Mysql"
- Previous message: phplists <email protected>: "RE: [PHP-DB] Multiple table select, but still returning row if no record exists in second table?"
- Maybe in reply to: Leif K-Brooks: "[PHP-DB] Multiple table select, but still returning row if no record exists in second table?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]