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

select Customers.cust_email from OrderItems,Orders,Customers where OrderItems.order_num=Orders.order_num and Orders.cust_id=Customers.cust_id and OrderItems.prod_id='BR01';