select cust_email from Customers C inner join Orders O on C.cust_id = O.cust_id inner join OrderItems OI on O.order_num = OI.order_num
where prod_id = 'BR01';
SQL99 返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件(二)(inner join..on..)
最新推荐文章于 2024-03-28 11:06:45 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)