select * from Plan,airport.name where plan.depart=airport.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