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