RIGHT OUTER JOIN
noun
say it: “RYTE OW-ter JOYN” /raɪt ˈaʊtər dʒɔɪn/
A join that returns every row from the right table, with matching rows from the left or NULLs where there's no match.
What is RIGHT OUTER JOIN in a relational database?
RIGHT OUTER JOIN — A join returning every right row and matching left rows, using NULLs when no left match exists.
SELECT customer.email, purchase_order.order_id
FROM customer
RIGHT OUTER JOIN purchase_order
ON purchase_order.customer_id = customer.customer_id;
In a sentence
- “The RIGHT JOIN kept every shipper, even those with no orders.”
Level: Apprentice · More SQL terms at this level
Updated