FULL OUTER JOIN
A join that keeps every row from both tables, pairing them where they match and filling NULLs where they do not.
In more detail
It is useful for comparing two lists to find what is missing on either side. SQLite supports it from version 3.39; MySQL does not support it at all.
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.
- outer join — A join that also keeps rows with no match, filling the other table's columns with NULL.
Taught in
- What An Outer Join Really Returns — PostgreSQL, Indexing & Relational Data Modeling