采用3表连接的方法,找出表与表之间关联的字段。

select c.cust_email
from OrderItems oi join Orders o on oi.order_num=o.order_num
join Customers c on o.cust_id=c.cust_id
where oi.prod_id="BR01";