select C.cust_email
from
(select order_num from OrderItems where prod_id='BR01') OI
join
Orders O
on OI.order_num = O.order_num
join
Customers C
on O.cust_id = C.cust_id