目录 一、题目二、代码三、运行结果 一、题目 二、代码 select cu.cust_email from Customers cu join ( select Orders.cust_id from OrderItems join Orders on OrderItems.order_num = Orders.order_num where OrderItems.prod_id = 'BR01' ) table1 on cu.cust_id = table1.cust_id 三、运行结果