select c.cust_email
from Customers c
where c.cust_id in (
select o.cust_id
from Orders o
left join OrderItems oi
on oi.order_num = o.order_num
where oi.prod_id = 'BR01'
)

select c.cust_email
from Customers c
where c.cust_id in (
select o.cust_id
from Orders o
left join OrderItems oi
on oi.order_num = o.order_num
where oi.prod_id = 'BR01'
)