Hi,
I have the following SQL statement which cause NOT ENOUGH MEMORY

SELECT Card_No AS cCardNo , s.SalesNo, s.sDate, s.pLocation AS Location, ;
     IIF(ISNULL(sTotal - RAmount), 0, sTotal - RAmount) AS Total, ;
     IIF(ISNULL(FLOOR(sTotal - RAmount)), 0, FLOOR(sTotal - RAmount)) AS SalesPoint  ;
FROM Member n  LEFT JOIN Sales s  ;
     ON Card_No == s.IDNumber  AND ( s.pLocation = 'ZONE 3    '  OR ;
     s.pLocation = 'ZONE 2    '  OR  s.pLocation = 'DAMBR     '  OR ;
     s.pLocation = 'ZONE 1    ' )  ;
INTO CURSOR csrCustom 

Therefore, I change it to :

SELECT Card_No AS cCardNo , s.SalesNo, s.sDate, s.pLocation AS Location, ;
     IIF(ISNULL(sTotal - RAmount), 0, sTotal - RAmount) AS Total, ;
     IIF(ISNULL(FLOOR(sTotal - RAmount)), 0, FLOOR(sTotal - RAmount)) AS SalesPoint  ;
FROM Member n  LEFT JOIN Sales s  ;
     ON Card_No == s.IDNumber  <B> WHERE </B> ( s.pLocation = 'ZONE 3    '  OR ;
     s.pLocation = 'ZONE 2    '  OR  s.pLocation = 'DAMBR     '  OR ;
     s.pLocation = 'ZONE 1    ' )  ;
INTO CURSOR csrCustom 

However, it return wrong result. The PLocation condition is not evaluated correctly. Any ideas?

Thank you