a

LEFT JOIN

will also return any rows from the left table that are not included in the right table (with

NULL

for the missing values)