连接和子查询
确定哪些订单购买了 prod_id 为 BR01 的产品（二）
https://www.nowcoder.com/practice/999aa31a9a504c60baa088d90d82e64d
select
o.cust_id,o.order_date
from Orders o,OrderItems oi
where o.order_num = oi.order_num
and oi.prod_id = 'BR01'
order by o.order_date;
select
cust_id,order_date
from Orders
where order_num in (
select order_num from OrderItems
where prod_id = 'BR01'
)
order by order_date;
投递快手等公司10个岗位 >