Self join

sql

SELECT e.employee_id, e.name, m.name AS manager_name
FROM employees e
LEFT JOIN employees m ON m.employee_id = e.manager_id;

Explanation

Self joins are common in hierarchical or parent-child tables.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Joins

Return rows with matches in both tables.

Open In sheetsqlsame section

Keep all rows from the left table and match rows from the right table.

Open In sheetsqlsame section

Keep all rows from the right table.

Open In sheetsqlsame section

Return matched and unmatched rows from both tables.

Open In sheetsqlsame section

Return the Cartesian product of two sets.

Open In sheetsqlsame section

Return all columns from a table.