183. 从不订购的客户（MySQL）（多表查询——表A存在 但表B不存在的数据）

1 题目

2 MySQL

2.1 方法一（A left join B on 条件 where B.列 is null）

select Name as Customers
from Customers left join Orders
    on Customers.Id = Orders.CustomerId
where Orders.CustomerId is null;

优化一下

select A.Name as Customers
from Customers as A left join Orders as B
    on A.Id = B.CustomerId
where B.CustomerId is null;