SELECT emp.EMP_CODE, emp.EMP_NAME, dep.DEPT_CODE, dep.DEPT_NAME
FROM TBL_EMPLOYEES emp
FULL OUTER JOIN TBL_DEPT dep 
ON dep.DEPT_CODE=emp.DEPT_CODE
ORDER BY emp.EMP_CODE, dep.DEPT_CODE