1、查询不在oders表customerid中的customers表的id,返回对应的名字。
# Write your MySQL query statement below
select Name as Customers
from Customers
where Id not in (select distinct CustomerId as Id from Orders)
2023-10-15 21:35:10
1、查询不在oders表customerid中的customers表的id,返回对应的名字。
# Write your MySQL query statement below
select Name as Customers
from Customers
where Id not in (select distinct CustomerId as Id from Orders)