Leetcode 183. 从不订购的客户(子查询、not in)

2021-04-01 17:03:39 浏览数 (1)

代码语言:javascript复制
# Write your MySQL query statement below
select Name  Customers from Customers where Id not in(
select c.Id 
    from Customers c,Orders o
    where c.Id = o.CustomerId)

0 人点赞