SELF JOIN in SQL — a practical guide to SQL SELF JOIN with clear examples you can reuse in real projects.
SQL Tutorial Series (53/100). Prefer one article? Read the complete SQL tutorial.
Short description
Common for employee→manager and category→parent patterns.
Self join
SELECT e.name AS employee, m.name AS manager
FROM employees e
LEFT JOIN employees m ON m.id = e.manager_id;