Self join a table

sql

SELECT e.id, e.full_name, m.full_name AS manager_name
FROM employees e
LEFT JOIN employees m ON m.id = e.manager_id;

Explanation

Self joins are common in hierarchical data such as org charts.

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 where both tables match.

Open In sheetsqlsame section

Return all rows from the left table and matching rows from the right table.

Open In sheetsqlsame section

Count child rows per parent.

Open In sheetsqlsame section

Return users who have at least one paid order.

Return users who have orders.

Create a readable query pipeline with `WITH`.