select cust_email from Customers where cust_id in( select cust_id from Orders where order_num in( select order_num from OrderItems where prod_id='BR01' ) ) 最笨的办法?层层提取