SQL Self Join

Joining a table to itself.

SELECT a.ename, b.ename
FROM emp a, emp b
WHERE a.mgr = b.empno;