What does LEFT JOIN return?

Question

Accepted Answer

A LEFT JOIN (or LEFT OUTER JOIN) always returns every row from the left table. When a left-table row has no match in the right table, the right-side columns are filled with NULL. This is useful for finding unmatched records: add WHERE right_table.id IS NULL to get left-table rows that have no corresponding right-table row.