SQL Self Join

SQL Self Join:

Joining a table to itself.

select a.ename, b.ename

from emp a, emp b

where a.mgr = b.empno;