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

ORDER BY EM.EMP_CODE ASC ,DE.DEPT_CODE ASC;