select distinct forderid from orderitem where itemcode=905 and quantity >= 2;select distinct forderid from orderitem where itemcode = 207 and quantity>0 and forderid in (select forderid from orderitem where itemcode = 905 and quantity>0) 这样写比较不简洁,但是查询速度比较快select distinct forderid from orderitem where itemcode = 207 and quantit...