Self Join

Joining the table itself is called self join.

Ex: SQL> select e1.empno,e2.ename,e1.job,e2.deptno from emp e1,emp e2 where    e1.empno=e2.mgr;