left join

A left outer join includes all of the records from the first (left) of two tables, even if there are no matching values for records in the second (right) table.