The LEFT JOIN Clause

Combines records from two tables. Returns all records from the table on the left side of the join, even if there are no matching records in the table on the right side of the join. The join is specified in the FROM clause. The syntax is:

FROM leftTable LEFT JOIN rightTable ON leftTable.field1 comparison-operator rightTable.field2