题解 | #确定哪些订单购买了 prod_id 为 BR01 的产品（二）#
确定哪些订单购买了 prod_id 为 BR01 的产品（二）
http://www.nowcoder.com/practice/999aa31a9a504c60baa088d90d82e64d
select a.cust_id,a.order_date
from
(select OrderItems.prod_id,Orders.cust_id,Orders.order_date
from OrderItems
inner join Orders
on OrderItems.order_num = Orders.order_num
where OrderItems.prod_id = 'BR01') as a
order by a.order_date
//子查询的用法
查看13道真题和解析
投递京东等公司10个岗位