牛客SQL学习 _必知必会_34_93 返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件（一）

---

一、题目

二、代码

select cu.cust_email 
from Customers cu
join
(
select Orders.cust_id
from OrderItems 
join Orders 
on OrderItems.order_num = Orders.order_num
where OrderItems.prod_id = 'BR01'
)  table1
on cu.cust_id = table1.cust_id

三、运行结果