题解 | 返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件(二)
select cust_email from Customers where cust_id in (select cust_id from Orders inner join OrderItems on Orders.order_num = OrderItems.order_num where prod_id = "BR01")
select cust_email from Customers where cust_id in (select cust_id from Orders inner join OrderItems on Orders.order_num = OrderItems.order_num where prod_id = "BR01")
相关推荐