Untitled

SELECT styleSupplierFactory.STYLE_NUMBER, cwSupplierFactory.COLORWAY_NUMBER, styleSupplierFactory.SUPPLIER_ID, styleSupplierFactory.FACTORY_ID
FROM ASF.PLM_STYLE_SUPPLIER_FACTORY styleSupplierFactory
LEFT JOIN ASF.PLM_CW_SUP_FAC cwSupplierFactory ON
	styleSupplierFactory.STYLE_SUPPLIER_FACTORY_ID = cwSupplierFactory.STYLE_SUPPLIER_FACTORY_ID
LEFT JOIN ASF.PLM_STS_SUP_FAC supFac ON 
	supFac.STYLE_SUPPLIER_FACTORY_ID = styleSupplierFactory.STYLE_SUPPLIER_FACTORY_ID;
--	supFac.STYLE_SUPPLIER_FACTORY_ID = cwSupplierFactory.STYLE_SUPPLIER_FACTORY_ID;

--LEFT JOIN GBSPID.XSEASON season ON 
--	season.SEASON_ID = supFac.SEASON_ID;