题解 | #买prod_id为BR01的所有顾客电子邮件#
返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件（二）
https://www.nowcoder.com/practice/c7aa73afc41f4dfc925baebdd175c345
select cust_email from OrderItems inner join Orders on OrderItems.order_num = Orders.order_num inner join Customers on Customers.cust_id = Orders.cust_id where prod_id ='BR01'
注意：多表连接的inner join写法
哔哩哔哩公司福利 443人发布