select t.cust_email from (select a.order_num, a.cust_id, b.cust_email from Orders a left join Customers b on a.cust_id = b.cust_id) as t where t.order_num in (select order_num from OrderItems where prod_id = "BR01")
select t.cust_email from (select a.order_num, a.cust_id, b.cust_email from Orders a left join Customers b on a.cust_id = b.cust_id) as t where t.order_num in (select order_num from OrderItems where prod_id = "BR01")