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