FULL OUTER JOIN keeps all rows from both tables, filling the missing side with NULL. See the union of LEFT and RIGHT joins visualized.
Join type
Data (click a cell to edit)
SELECT * FROM A FULL OUTER JOIN B ON A.key = B.key
ON A.key = B.key — empty keys are treated as SQL NULL and never match
Table A
Table B
Result
| A.key | A.val | B.key | B.val |
|---|---|---|---|
| 1 | kim | 1 | dev |
| 3 | park | 3 | hr |
| 2 | lee | NULL | NULL |
| NULL | NULL | 4 | fin |
Edit a key or add a row — the connector lines and result update instantly. The 'Duplicate key' preset shows why LEFT JOIN row counts can grow.
FULL OUTER JOIN combines LEFT and RIGHT: every row from both tables survives, with NULL padding on the unmatched side.
Its killer use case is diffing two datasets — FULL JOIN the old and new tables, filter where either key IS NULL, and you instantly see rows that exist on only one side.
MySQL doesn't support FULL OUTER JOIN; the standard workaround is UNION of a LEFT JOIN and a RIGHT JOIN. SQL JOIN Visualizer