Kappa

-----------------------------------------
select c.CompanyPlanceName
from
Flights a inner join Routes b
on a.IDRoute = b.IDRoute
inner join CompanyPlaneName c
on c.CompanyPlaneID = b.CompanyplaneID
where a.IDFlight = @param
---------------------------------------
select c.CompanyPlaneName
from CompanyPlanceName c
where c.CompanyPlaneID in
(select CompanyplaneID from
(select b.IDRoute,b.CompanyplanetID
from Routes b
where b.IDRoute in
(select IDRoute from
(select a.IDFlight,a.IDRoute
from Flights a
where a.IDFlight = @param) as STEP1
)
) as STEP2)