select cust_email from Orders inner join OrderItems on OrderItems.order_num = Orders.order_num inner join Customers on Orders.cust_id = Customers.cust_id where OrderItems.prod_id = 'BR01'
select cust_email from Orders inner join OrderItems on OrderItems.order_num = Orders.order_num inner join Customers on Orders.cust_id = Customers.cust_id where OrderItems.prod_id = 'BR01'
牛客博客，记录你的成长
京公网安备 11010502036488号