outer join

A relational database operation that selects rows from two tables regardless of whether the specified columns contain corresponding values. An outer join will return all rows from the primary table and any rows from the secondary table where the value in the specified column of the primary table is equal to the value in the specified column of the secondary table. See also inner join.