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.

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

Updated