题目:
题解:
多表联结。
这里要找从不订购的客户,即客户从未在Orders表出现,即Customers表左联Orders表,找出Orders表中Id is null的数据。
select Customers.Name as Customers
from Customers
left join Orders
on Customers.Id = Orders.CustomerId
where Orders.Id is null
多表联结。
这里要找从不订购的客户,即客户从未在Orders表出现,即Customers表左联Orders表,找出Orders表中Id is null的数据。
select Customers.Name as Customers
from Customers
left join Orders
on Customers.Id = Orders.CustomerId
where Orders.Id is null