SUM(CASE WHEN P.EVENTID=8015 THEN P.AMOUNT ELSE 0 END) AS ITEM1, SUM(CASE WHEN P.EVENTID=8007 THEN P.AMOUNT ELSE 0 END) AS ITEM2, SUM(CASE WHEN P.EVENTID BETWEEN 1000 AND 1400 THEN P.AMOUNT ELSE 0 END ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback