See items present in one side, the other side, or both.
Section: Common join patterns
Full outer join to compare two datasets
sql
sql
SELECT a.sku AS a_sku, b.sku AS b_sku
FROM inventory_snapshot_a a
FULL OUTER JOIN inventory_snapshot_b b
ON b.sku = a.sku;Explanation
Great for reconciliation and migration verification.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing Common join patterns
Emulate FULL OUTER JOIN where unsupported
Use a `LEFT JOIN` + unmatched rows from the other side via `UNION ALL`.
Inner join active users with subscriptions
Only users who have a matching subscription row appear.
Left join to find users without subscriptions
Find unmatched left-side rows by checking for `NULL` on the right.