# 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.

```sql
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](https://www.ask-codey.com/glossary?category=sql&level=2)

Updated: November 9, 2026

Source: https://www.ask-codey.com/glossary/right-outer-join
