题解 | #确定哪些订单购买了 prod_id 为 BR01 的产品（二）#
确定哪些订单购买了 prod_id 为 BR01 的产品（二）
http://www.nowcoder.com/practice/999aa31a9a504c60baa088d90d82e64d
SELECT o.cust_id cust_id, o.order_date order_date FROM OrderItems oi INNER JOIN Orders o ON (oi.prod_id = 'BR01') AND (oi.order_num = o.order_num) ORDER BY order_date;
