select emp.EMP_CODE,emp.EMP_NAME,dept.DEPT_CODE,dept.DEPT_NAME
from TBL_EMPLOYEES as emp full outer join TBL_DEPT as dept on emp.DEPT_CODE = dept.DEPT_CODE
order by emp.EMP_CODE,dept.DEPT_CODE;