题解 | 确定哪些订单购买了 prod_id 为 BR01 的产品(二)
select
cust_id,
order_date
from
OrderItems ori
join Orders ord on ori.order_num = ord.order_num
where
prod_id = 'BR01'
order by
order_date asc
select
cust_id,
order_date
from
OrderItems ori
join Orders ord on ori.order_num = ord.order_num
where
prod_id = 'BR01'
order by
order_date asc
相关推荐