在途订单信息.frmSELECT TW.WAYBILL_NUMBER AS 交货号, TW.RECEIVING_PROVINCE AS 区域, TW.CUSTOMER AS 客户名称, SUM(TW.PIECE) AS 数量 FROM TMS_WAYBILL TW WHERE TW.WAYBILL_STATUS = 2 AND TW.RECEIVING_PROVINCE <> ' ' GROUP BY TW.WAYBILL_NUMBER,TW.CUSTOMER,TW.RECEIVING_PROVINCE