8일차 # 5-15: Self-Join

- Join On 사용

  select e.empno, e.ename, m.empno, m.ename

  from emp e

  join emp m

  on (e.mgr = m.empno);

↓ ↓ ↓

<Oracle Syntax>

  select e.empno, e.ename, m.empno, m.ename

  from emp e, emp m

  where e.mgr = m.empno;