题解 | #返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件（二）#

select Customers.cust_email as cust_email
from Customers
join Orders on Orders.cust_id=Customers.cust_id
join OrderItems on OrderItems.order_num=Orders.order_num
where OrderItems.prod_id='BR01';