FULL OUTER JOIN
noun
say it: “FUL OW-ter JOYN” /fʊl ˈaʊtər dʒɔɪn/
A join that returns all rows from both tables, matched where possible and with NULLs where not.
What is FULL OUTER JOIN in a relational database?
FULL OUTER JOIN — A join returning matched rows plus unmatched rows from both sides.
SELECT customer.email, purchase_order.order_id
FROM customer
FULL OUTER JOIN purchase_order
ON purchase_order.customer_id = customer.customer_id;
In a sentence
- “A FULL OUTER JOIN showed both customers with no orders and orders with no customer.”
Level: Apprentice · More SQL terms at this level
Updated