183.从不订购的客户
某网站包含两个表,Customers 表和 Orders 表。编写一个 SQL 查询,找出所有从不订购任何东西的客户。
Customers 表:
Id | Name |
---|---|
1 | Joe |
2 | Henry |
3 | Sam |
4 | Max |
Orders 表:
Id | CustomerId |
---|---|
1 | 3 |
2 | 1 |
例如给定上述表格,你的查询应返回:
Customers |
---|
Henry |
Max |
来源:力扣(LeetCode)
链接:https://leetcode-cn.com/problems/customers-who-never-order
题解
求差集,采用外连接加筛选即可,注意筛选条件不能是=null,可以是 is null;
select c.Name as 'Customers'
from Customers as c
left join Orders as o
on c.Id = o.CustomerId
where o.CustomerId is null;