Unlocking the Power of FULL OUTER JOIN in SQL: Performance, Use Cases & Examples

The JOIN statement is one of the most common operations SQL developers perform. Yet in a world ruled by Inner and Left Joins, the poor Full Outer Join is like Cinderella before the ball – allowed out on only the rarest of occasions. In an (unscientific) survey I once performed of SQL developers at one Fortune 100 firm, half of the developers had never used a Full Outer Join in production code, and the rest had used it in a tiny handful of occasions.

The Mangled Outer Join

Understanding Outer Joins in SQL

The basics of outer joins are shown in this short piece that explains how they work.

Outer Joins

Outer Join – What am I missing (SQL Spackle)

This article shows how to find missing rows in a table using a outer join.

Outer join with condition