首页 > 代码库 > 183. Customers Who Never Order

183. Customers Who Never Order

# Write your MySQL query statement belowselect Name Customers from Customerswhere Customers.Id  not in    (   select Customers.Id        from Orders,Customers        where Customers.Id=Orders.CustomerId )

 

183. Customers Who Never Order