题目
答案
Select customers.name as Customers from customers where customers.id not in (select customerId from orders)
解析
本体用了子表,从子表中选出不是顾客id的,返回name改为Customers名字即可
Select customers.name as Customers from customers where customers.id not in (select customerId from orders)
本体用了子表,从子表中选出不是顾客id的,返回name改为Customers名字即可