本题是一道子查询,先选出那些有订单的用户,再使用not in来排除
注意使用group by防止有多个订单的用户
select
Name as Customers
from
Customers
where
Id not in
(
select
CustomerId
from
Orders
group by CustomerId
)
本题是一道子查询,先选出那些有订单的用户,再使用not in来排除
注意使用group by防止有多个订单的用户
select
Name as Customers
from
Customers
where
Id not in
(
select
CustomerId
from
Orders
group by CustomerId
)