这里使用较为简单粗暴的三表连接后再进行条件筛选

select 
cust_email 
from Customers c join Orders o 
on c.cust_id=o.cust_id join OrderItems o2 
on o.order_num=o2.order_num
where o2.prod_id='BR01';