- 题目描述
- 解法代码
SELECT Customers.Name AS Customers
FROM Customers
LEFT JOIN Orders
ON Customers.ID=Orders.CustomerId
WHERE CustomerId is NULL;
- SQL知识点
外联结-OUTER JOIN
SELECT Customers.Name AS Customers
FROM Customers
LEFT JOIN Orders
ON Customers.ID=Orders.CustomerId
WHERE CustomerId is NULL;