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