183. 从不订购的客户

SELECT 
    name AS Customers 
FROM 
    Customers
WHERE Customers.Id not in (SELECT DISTINCT CustomerId FROM Orders) 

 

posted on 2021-08-20 22:23  一仟零一夜丶  阅读(18)  评论(0)    收藏  举报