# INNER JOIN

*noun*

say it: **“IN-er JOYN”** **/ˈɪnər dʒɔɪn/**

A join that returns only the rows that have a match in both tables.

## What is **INNER JOIN** in a relational database?

**INNER JOIN** — A join returning only row combinations that satisfy its join condition.

```sql
SELECT customer.email, purchase_order.order_id
FROM customer
INNER JOIN purchase_order
    ON purchase_order.customer_id = customer.customer_id;
```

## In a sentence

- “The **INNER JOIN** left out products with no category.”

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/inner-join
