What is a FULL OUTER JOIN?

< 1 min read

A FULL OUTER JOIN returns all records from both tables.
Matching rows are combined, and non-matching rows show NULLs on the missing side.
It is used when we want a complete view of data from both sources.
In my project, we used it to compare planned targets and actual sales.
This helped identify missing records on either side.
FULL OUTER JOIN is useful for reconciliation and data quality checks.
Not all databases support it directly, so workarounds are sometimes needed.

Power BI Essentials