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