SELECT cust_email
from(
    SELECT cust_id
    FROM OrderItems OI, Orders O
    where OI.prod_id = 'BR01' and OI.order_num=O.order_num
) as t1, Customers as C
where C.cust_id = t1.cust_id