Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT E1.ename,D1.dname,E2.ename,D2.dname FROM dept D1, dept D2, emp E1, emp E2 WHERE E1.job = 'Manager' and E1.empno = E2.mgr and E1.deptno != E2.deptno and E1.deptno = D1.deptno AND E2.deptno = D2.deptno
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement