题解 | #返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件（二）#
返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件（二）
http://www.nowcoder.com/practice/c7aa73afc41f4dfc925baebdd175c345
select cust_email
from Customers
inner join Orders
on Orders.cust_id = Customers.cust_id
inner join OrderItems
on OrderItems.order_num = Orders.order_num
where prod_id = 'BR01'
腾讯开奖351人在聊
查看9道真题和解析