分析:涉及到三个表:product、laptop、pc表
表结构详见:点这里
涉及到嵌套查询、连接查询
上代码:
select distinct maker
from product,laptop
where product.model=laptop.model and maker not in (
select maker
from product,pc
where product.model=pc.model
);
分析:涉及到三个表:product、laptop、pc表
表结构详见:点这里
涉及到嵌套查询、连接查询
上代码:
select distinct maker
from product,laptop
where product.model=laptop.model and maker not in (
select maker
from product,pc
where product.model=pc.model
);