SELECT CATEGORY_PK_KEY,CATEGORY_NAME,ITEM_PK_KEY,ITEM_NAME,SUM_PURCHASES FROM POA_PORTAL_PDIST1 WHERE QUARTER = 'C' AND SUM_PURCHASES IS NOT NULL AND SUM_PURCHASES <> 0
View Text - HTML Formatted
SELECT CATEGORY_PK_KEY , CATEGORY_NAME , ITEM_PK_KEY , ITEM_NAME , SUM_PURCHASES FROM POA_PORTAL_PDIST1 WHERE QUARTER = 'C' AND SUM_PURCHASES IS NOT NULL AND SUM_PURCHASES <> 0