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

分析

思路：

• 内联结。from Orders inner join OrderItems on Orders.order_num=OrderItems.order_num inner join Customers on Orders.cust_id=Customers.cust_id
• 筛选。where prod_id='BR01'

代码

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