文章目录 从不订购的客户题目解析 从不订购的客户 题目 解析 select c.Name as Customers from Customers as c left join Orders as o on c.ID = o.CustomerID where o.CustomerID is null; 左连接时候,左边的显示完整表,右边的不满足on后面的条件则为null,注意判断不存在的值时用is null,不是 == None.