# 多重子查询 嵌套
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')
)
;