Outer Join

A join that does not require every row in the two joined tables to have a matching row. The joined result retains each row – even if no other matching row exists. Outer joins subdivide further into left outer joins, right outer joins, and full outer joins, depending on whether one retains the rows from the left table, right table, or both.