题解 | #返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件（二）#
返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件（二）
http://www.nowcoder.com/practice/c7aa73afc41f4dfc925baebdd175c345
SELECT c.cust_email FROM OrderItems a INNER JOIN Orders b ON a.order_num = b.order_num INNER JOIN Customers c ON b.cust_id=c.cust_id WHERE a.prod_id = 'BR01';
投递华为等公司8个岗位 >