select cust_id from ( select * from OrderItems where item_price>=10 ) as A inner join Orders on A.order_num=Orders.order_num 根据提示使用的子查询,明显先查询价格>=10的产品,之后想到顾客id与满足条件的产品不在同一张表里,于是内连接一下