Customers Who Never Order.md

Notes

Use a LEFT JOIN

MySQL Solution

SELECT Name AS Customers FROM Customers
LEFT JOIN Orders
ON Customers.Id = Orders.CustomerId
WHERE Orders.CustomerId IS NULL

Links

• github.com/RodneyShag