题解 | #确定哪些订单购买了 prod_id 为 BR01 的产品（二）#

select cust_id,order_date from Orders 
where  order_num in (select order_num from OrderItems where prod_id='BR01')
order by order_date;

select cust_id,order_date 
from Orders join OrderItems on Orders.order_num=OrderItems.order_num
where prod_id='BR01'
order by order_date;