MySQL SQL

MySQL Self Join

Join a table to itself using different aliases.

SELECT e.name, m.name AS manager
FROM employees e
LEFT JOIN employees m ON m.id = e.manager_id;

Self joins are useful for hierarchical data such as employees and managers.