SELECT DISTINCT(SIC_CODE) SIC_CODE , MAX(LAST_UPDATE_DATE) LAST_UPDATE_DATE FROM HZ_PARTIES WHERE SIC_CODE IS NOT NULL GROUP BY SIC_CODE UNION ALL SELECT DISTINCT(SIC_CODE) SIC_CODE , MAX(LAST_UPDATE_DATE) LAST_UPDATE_DATE FROM HZ_CUST_SITE_USES_ALL WHERE SIC_CODE IS NOT NULL GROUP BY SIC_CODE UNION ALL SELECT DISTINCT(STANDARD_INDUSTRY_CLASS) SIC_CODE , MAX(LAST_UPDATE_DATE) LAST_UPDATE_DATE FROM PO_VENDORS WHERE STANDARD_INDUSTRY_CLASS IS NOT NULL GROUP BY STANDARD_INDUSTRY_CLASS