Hi..

Have a tricky question here. Your help is appreciated !

I have 3 tables as below

TABLE A

DEPT_NBR MGT_NBR MGR_NAME
1 111 ABD
6 222 XXX
2 33 RRR
4 444 JJJJ
3 555 DDDD
7 77 NNNN

TABLE B

EMP_NBR EMP_NAME DEPT_NBR MGR_NBR
1 DON ...