Hi All,

I have the following SQL statement that returns several rows when running with VFP6.

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 ;
   csrTemp

The same statement returns no (zero) rows when running with VFP8.

Anyone know why or what is going wrong?

TIA

Regards,

Mike