Skip to main content
Journey Uncommon Logo
JourneyUncommon
mediumSQLself-joinsSingle-choice MCQ

In a self-join to find each employee paired with their manager, why is the join condition written as e.manager_id = m.employee_id rather than e.manager_id = m.manager_id?

SELECT e.name AS employee, m.name AS manager FROM employees e JOIN employees m ON e.manager_id = m.employee_id;