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