Try
SELECT pl.ident, ad.name AS depart, aa.name AS arrival
FROM plan pl ;
JOIN airport ad ON pl.depart = ad.code ;
JOIN airport aa ON pl.arrival = aa.code
>So i have two table
>
>PLAN
>============
>ident i
>depart c(20)
>arrival c(20)
>
>values
>------
>-1,mon,tor
>
>
>AIRPORT
>=============
>code c(20)
>name c(50)
>
>values
>------
>-mon,montreal
>-tor,toronto
>
>so the field arrival and depart is the same of airport.code.
>
>
>so i want to have one cursor for this two table
>
>ex :
>
>ident = 1
>depart = montreal
>arrvial = toronto
>
>
>thks
--sb--