LEFT JOIN

A LEFT JOIN returns every row from the left (first) table, plus matching rows from the right table.