outer join

A join in which all the records from one table are added to the Recordset object, even if there are no matching values in the joined field from the second table. Records from the second table are combined with those from the first table only when there are matching values in the joined fields. Null records are joined when there is no match.