题解 | 三表内连接求解
返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件(一)
https://www.nowcoder.com/practice/962b16554fbf4b99a87f4d68020c5bfb
SELECT Customers.cust_email FROM Orders JOIN Customers on Customers.cust_id = Orders.cust_id Join OrderItems on OrderItems.order_num = Orders.order_num WHERE OrderItems.prod_id = "BR01";