SELECT 
    T1.EMP_CODE AS EMP_CODE,
    T1.EMP_NAME AS EMP_NAME,
    T2.DEPT_CODE AS DEPT_CODE,
    T2.DEPT_NAME AS DEPT_NAME
FROM
    TBL_EMPLOYEES AS T1
    LEFT OUTER JOIN TBL_DEPT AS T2
    ON T1.DEPT_CODE = T2.DEPT_CODE
ORDER BY
    EMP_CODE ASC,
    DEPT_CODE ASC;