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