思路1:
左连接,连接键为Customers的ID字段和Orders的CustomerId字段。连接完后,CustomerId中空值即为所求客户。
代码:
select c.name as Customers
from Customers c
left join Orders o on o.CustomerId=c.Id
where o.CustomerId is null;
思路2:
直接选择即可。
代码2:
SELECT Name AS Customers
FROM Customers
WHERE Customers.Id NOT IN(SELECT CustomerId FROM Orders)
分析:
第二种思路在LeetCode中为最优解。可见连接表应该是慢一些。