You've typo in your code.

	     JOIN FFAIRPT APA ON FFCONSOL.ARRIVAL_PORT = APD.CODE;
* sould be
	     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