子查询中也要标明where关联条件      select C.cust_name, O.order_num, (select sum(OI.quantity*OI.item_price)                                    from OrderItems as OI                   ...