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