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