leetcode 183 表的合并

我们需要将两个表关联才行，所以可以想到left join

解法一：left join

# Write your MySQL query statement below
select
    Name as Customers
from
    (select
        Name, CustomerId
    from
        Customers
    left join
        Orders
    on
        Customers.Id = Orders.CustomerId
    ) db1
where
    CustomerId is null

解法二：无合并直接去掉

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

我们可以将第二个表中的一列取出来，然后找不在里面的即可，这样更简单。