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