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

Taught in

References