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