SELECT 
EMP.EMP_CODE,
EMP.EMP_NAME,
DEP.DEPT_CODE,
DEP.DEPT_NAME

FROM TBL_EMPLOYEES AS EMP

LEFT OUTER JOIN TBL_DEPT AS DEP 
ON DEP.DEPT_CODE = EMP.EMP_CODE,
RIGHT OUTER JOIN BL_DEPT AS DEP 
ON DEP.DEPT_CODE = EMP.EMP_CODE,

ORDER BY
EMP.EMP_CODE ASC,
DEP.DEPT_CODE;