Self Joins and Table Aliases in MySQL

Self Join Example

SELECT a.name AS emp1, b.name AS emp2 
FROM employees a, employees b 
WHERE a.manager_id = b.id;

Aliases (a, b) help refer to the same table twice.