思路:将前表和后表按Id=CustomerId进行左连接,这样只需要筛选出Orders.Id 为null的表项即可;
代码:
# 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
思路:将前表和后表按Id=CustomerId进行左连接,这样只需要筛选出Orders.Id 为null的表项即可;
代码:
# 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