题解 | #返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件（二）#
返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件（二）
http://www.nowcoder.com/practice/c7aa73afc41f4dfc925baebdd175c345
SELECT c.cust_email cust_email FROM OrderItems oi INNER JOIN Orders o ON (oi.prod_id = 'BR01') AND (oi.order_num = o.order_num) INNER JOIN Customers c ON o.cust_id = c.cust_id;
投递大疆等公司7个岗位
查看5道真题和解析