涉及到的表:pc、product
select maker
from (
select maker,model
from product
where model in (
select model
from pc
)
)as a
group by maker
having count(maker)=3
涉及到的表:pc、product
select maker
from (
select maker,model
from product
where model in (
select model
from pc
)
)as a
group by maker
having count(maker)=3