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