# Self Join

*noun*

say it: **“SELF JOYN”** **/sɛlf dʒɔɪn/**

Joining a table to itself, such as matching each employee to their manager in the same table.

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

**Self Join** — A query that joins a table to another reference to the same table.

```sql
SELECT employee.name, manager.name AS manager_name
FROM employee
LEFT JOIN employee AS manager
    ON manager.employee_id = employee.manager_id;
```

## In a sentence

- “A **self join** on Employees showed each employee beside their manager's name.”

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