嵌套查询 多结果in

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