183.从不订购的顾客

分类: 文章 • 2024-11-10 23:05:04

183.从不订购的顾客

解析

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

通过select 查询 Name 并 as Customers

左外连接查询

当 CustomerId为 null；