outer join

A join that also keeps rows with no match, filling the other table's columns with NULL.

In more detail

A left join keeps every row of the left table, a right join every row of the right table, and a full outer join every row of both. The NULLs it adds are made by the join, not stored in any table.

Related terms

Taught in

References