MySQL/Problem Solving

[LeetCode] 183. Customers Who Never Order

hanshow113 2022. 2. 6. 20:35

 

SELECT Customers.name AS Customers
FROM Customers
     LEFT JOIN Orders ON Customers.id = Orders.CustomerId
WHERE CustomerId IS NULL