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

可以使用嵌套查询和inner join