SELECT
    TD.DEPT_CODE,
    TD.DEPT_NAME,
    OD.ORDER_NO,
    TC.CUST_CODE,
    TC.CUST_NAME,
    OD.ORDER_AMT

FROM
    TBL_ORDERS AS OD
    INNER JOIN TBL_DEPT AS TD
        ON TD.DEPT_CODE = OD.DEPT_CODE
    
    LEFT OUTER JOIN TBL_CUST AS TC
    ON TC.CUST_CODE = OD.CUST_CODE
    
ORDER BY
    OD.DEPT_CODE ASC,
    OD.ORDER_NO ASC;