outer join

A join that includes all rows regardless of whether there is a matching row.