Courses / SQL
12. FULL OUTER JOIN
A type of join that returns all rows when there is a match in either left or right table.
1 min read Chapter 12 of 29
SQL
FULL OUTER JOIN
A FULL OUTER JOIN retrieves all records from both tables, matching where possible.
"I need to see all customers and their orders, even if some customers haven't ordered anything."
A FULL OUTER JOIN combines results from two tables, showing all rows from both, with NULLs in places where there are no matches.
"I need to see all customers and their orders, even if some customers haven't ordered anything."
A FULL OUTER JOIN combines results from two tables, showing all rows from both, with NULLs in places where there are no matches.