SELECT EMP_CODE,EMP_NAME,TBL_DEPT.DEPT_CODE,DEPT_NAME 
FROM TBL_EMPLOYEES FULL OUTER JOIN TBL_DEPT
        ON TBL_EMPLOYEES.DEPT_CODE = TBL_DEPT.DEPT_CODE 
ORDER BY TBL_EMPLOYEES.EMP_CODE,TBL_DEPT.DEPT_CODE;