select
 T2.EMP_CODE
 ,T2.EMP_NAME
 ,T1.DEPT_CODE
 ,T1.DEPT_NAME
from 
 tbl_dept T1 full join tbl_employees T2 
on T1.DEPT_CODE = T2.DEPT_CODE
order by T2.EMP_CODE asc, T1.DEPT_CODE asc;