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

分析

思路：

• 内联结。from Orders inner join OrderItems on Orders.order_num=OrderItems.order_num
• 筛选。where prod_id='BR01'

代码

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