SELECT SUPPLIER_PK_KEY,SUPPLIER_NAME,SUPPLIER_SITE_PK_KEY,SUPPLIER_SITE_NAME,SUM_PURCHASES FROM POA_PORTAL_PDIST2 WHERE QUARTER = 'L' AND SUM_PURCHASES <> 0 AND SUM_PURCHASES IS NOT NULL
View Text - HTML Formatted
SELECT SUPPLIER_PK_KEY , SUPPLIER_NAME , SUPPLIER_SITE_PK_KEY , SUPPLIER_SITE_NAME , SUM_PURCHASES FROM POA_PORTAL_PDIST2 WHERE QUARTER = 'L' AND SUM_PURCHASES <> 0 AND SUM_PURCHASES IS NOT NULL