题解 | #确定哪些订单购买了 prod_id
确定哪些订单购买了 prod_id 为 BR01 的产品（二）
https://www.nowcoder.com/practice/999aa31a9a504c60baa088d90d82e64d
select
cust_id,
order_date
from
Orders
inner join
OrderItems
on
OrderItems.order_num=Orders.order_num
and OrderItems.prod_id='BR01'
order by
order_date
查看1道真题和解析