>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 > >>
>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 >>
SELECT Card_No AS cCardNo , s.SalesNo, s.sDate, s.pLocation AS Location, ; NVL(sTotal - RAmount, 0) AS Total, ; NVL(FLOOR(sTotal - RAmount), 0) AS SalesPoint ; FROM Member n LEFT JOIN Sales s ; ON n.Card_No == s.IDNumber ; AND INLIST(s.pLocation,'ZONE 3 ','ZONE 2 ','DAMBR ', 'ZONE 1 ' ) ; INTO CURSOR csrCustom