题解 | #返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件（一）#
返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件（一）
http://www.nowcoder.com/practice/962b16554fbf4b99a87f4d68020c5bfb
SELECT c.cust_email FROM Customers c, (SELECT a.prod_id,a.order_num,b.cust_id FROM OrderItems a INNER JOIN Orders b ON a.order_num=b.order_num WHERE a.prod_id= 'BR01') d WHERE c.cust_id=d.cust_id;
投递牛客等公司
Momenta公司福利 596人发布