183. 从不订购的客户 + 多表查询
183. 从不订购的客户
LeetCode_MySql_183
题目描述
代码实现
# Write your MySQL query statement below
select Name as 'Customers'
from Customers
where Customers.Id not in
(
select CustomerId from Orders
);
Either Excellent or Rusty
# Write your MySQL query statement below
select Name as 'Customers'
from Customers
where Customers.Id not in
(
select CustomerId from Orders
);