AI engineering glossary · SQL databases
What is FULL OUTER JOIN?
FULL OUTER JOIN (also called FULL JOIN): A join that keeps all rows from both tables, matching where it can and filling the other side with NULL where it cannot. It is useful for reconciling two lists to see what is in one, the other or both.
FULL OUTER JOIN: an example
Comparing this month's and last month's subscriber lists to find who joined, who left and who stayed.
Related terms
More SQL databases terms
Where you learn it
FULL OUTER JOIN is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.