RIGHT OUTER JOIN

A join returning every right row and matching left rows, using NULLs when no left match exists.

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;

Level: Apprentice · More Database terms at this level

Updated September 27, 2026