You've typo in your code.
JOIN FFAIRPT APA ON FFCONSOL.ARRIVAL_PORT = APD.CODE;
JOIN FFAIRPT APA ON FFCONSOL.ARRIVAL_PORT = APA.CODE;
>this is my code
>when i do
>select * from ffconsol where ident = 21018
>its work i obtains one record
>
>but when i do that
>SELECT FFCONSOL.MAWB_MBL,;
> APD.DESCR AS DEPART,;
> APA.DESCR AS ARRIVAL;
> FROM FFCONSOL;
> JOIN FFAIRPT APD ON FFCONSOL.DEPART_PORT = APD.CODE;
> JOIN FFAIRPT APA ON FFCONSOL.ARRIVAL_PORT = APD.CODE;
> WHERE FFCONSOL.IDENT = 21018;
> INTO CURSOR LABEL_4 READWRITE
>it doest work
--sb--