SELECT; IIF(ISNULL(a.T_id),b.T_id,a.T_id) AS T_id,; IIF(ISNULL(a.REFERENCE),b.REFERENCE,a.REFERENCE) AS REFERENCE,; IIF(ISNULL(a.DATE),b.DATE,a.DATE) AS DATE,; a.gl_Amt,; b.Sub_Amt; FROM ; csrTemp1 a FULL OUTER JOIN ; csrTemp2 b ON ; b.T_id=a.T_id; WHERE ; a.gl_Amt<>b.Sub_Amt; INTO CURSOR ; csrTempThe same statement returns no (zero) rows when running with VFP8.