SELECT TE.EMP_CODE,
TE.EMP_NAME,
TD.DEPT_CODE,
TD.DEPT_NAME

FROM TBL_EMPLOYEES AS TE

FULL OUTER JOIN TBL_DEPT AS TD

ON TE.DEPT_CODE = TD.DEPT_CODE

ORDER BY TE.EMP_CODE ASC,TD.DEPT_CODE ASC;