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
- LEFT JOIN — A join that keeps every row of the left table and adds the matching right-hand rows, or NULLs when there is no match.
- RIGHT JOIN — The mirror of a left join: keeps every row of the right-hand table.
- FULL OUTER JOIN — A join that keeps every row from both tables, pairing them where they match and filling NULLs where they do not.
- inner join — A join that keeps only the pairs of rows that satisfy the ON rule, dropping rows with no match on either side.
Taught in
- What An Outer Join Really Returns — PostgreSQL, Indexing & Relational Data Modeling