select cust_id,order_date from Orders where order_num in
(select order_num from OrderItems where prod_id = 'BR01')
order by order_date;
SQL92 确定哪些订单购买了 prod_id 为 BR01 的产品(一)(子查询)
![](https://img-home.csdnimg.cn/images/20240711042549.png)
select cust_id,order_date from Orders where order_num in
(select order_num from OrderItems where prod_id = 'BR01')
order by order_date;