SELECT
    DP.DEPT_CODE
    , DP.DEPT_NAME
    , OD.ORDER_NO
    , CS.CUST_CODE
    , CS.CUST_NAME
    , OD.ORDER_AMT 
FROM
    TBL_ORDERS AS OD

    INNER JOIN TBL_DEPT AS DP 
        ON DP.DEPT_CODE = OD.DEPT_CODE
        
    LEFT OUTER JOIN TBL_CUST AS CS
        ON CS.CUST_CODE = OD.CUST_CODE 
ORDER BY
    OD.DEPT_CODE ASC
  , OD.ORDER_NO;