您好,欢迎来到爱够旅游网。
搜索
您的当前位置:首页183. 从不订购的客户

183. 从不订购的客户

来源:爱够旅游网

sql(not in):

# Write your MySQL query statement below
select Name as Customers from Customers
where Id not in (select CustomerId from Orders)

sql(left join):

# Write your MySQL query statement below
select Name as Customers From
Customers left join Orders on Customers.id = Orders.CustomerId 
where Orders.id is null

因篇幅问题不能全部显示,请点此查看更多更全内容

Copyright © 2019- igbc.cn 版权所有 湘ICP备2023023988号-5

违法及侵权请联系:TEL:199 1889 7713 E-MAIL:2724546146@qq.com

本站由北京市万商天勤律师事务所王兴未律师提供法律服务