183. Customers Who Never Order

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

 

posted @ 2016-08-28 11:06  阿怪123  阅读(88)  评论(0)    收藏  举报