题解 | #精简SQL#
返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件(一)
https://www.nowcoder.com/practice/962b16554fbf4b99a87f4d68020c5bfb
对3个表进行内连接
select distinct(ct.cust_email) from Customers as ct inner join Orders as o on ct.cust_id = o.cust_id inner join OrderItems as oi on oi.order_num = o.order_num and oi.prod_id = 'BR01'