A self-join joins a table with itself, using two distinct aliases, to compare rows of the same table or to walk a hierarchical relationship, such as an employee and their manager. The alias is mandatory to tell the two roles apart.
Example
SELECT e.nom, m.nom AS manager
FROM employes e LEFT JOIN employes m ON m.id = e.manager_id;