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.
MySQL SQL
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.