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 csrCustomTherefore, 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 csrCustomHowever, it return wrong result. The PLocation condition is not evaluated correctly. Any ideas?