涉及到的表:product、pc、laptop
select maker
from product
where model in (
select a.model model
from(
select model,speed
from pc
union
select model,speed
from laptop
)as a
where a.speed=(
select max(b.speed)
from(
select model,speed
from pc
union
select model,speed
from laptop
)b
)
)
注意临时表的用法!