# Natural Join

A join matching equally named columns automatically and returning one copy of each matched column.

## What is **Natural Join** in a relational database?

**Natural Join** — A join matching equally named columns automatically and returning one copy of each matched column.

```sql
SELECT customer_id, order_id
FROM customer
NATURAL JOIN purchase_order;
```

Level: Master · [More Database terms at this level](https://www.ask-codey.com/glossary/subjects/database/master)

Updated: September 27, 2026

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