SELECT; Work_Table.Code, MAX(Ref_Table.Code) as max_code; FROM Work_Table ; INNER JOIN Ref_Table ; ON Work_Table.Code = STRTRAN(Ref_Table.Code, " ", "") ; GROUP BY 1 ; INTO CURSOR temp1 SELECT; temp1.Code, ref_Table.Key, temp1.max_Code ; FROM temp1 ; JOIN Ref_Table ; ON temp1.max_Code = Ref_Table.Code ; INTO CURSOR crsresultBTW, I couldn't get the first select work with ALLTRIM() because VFP just ignored it. That's why I replaced it with STRTRAN().
>SELECT; > Work_Table.Code,Key_Table.Key,MAX(Ref_Table.Code); > FROM Work_Table; > INNER JOIN Ref_Table; > ON Work_Table.Code=ALLTRIM(Ref_Table.Code); > GROUP BY 1 >>