select ITEM_CODE AS ITEM,ITEM_NAME AS I_NAME,CL_NAME AS C_NAME,SIZE_NAME AS S_NAME
FROM ITEM
	 CROSS JOIN COLOR_TBL,SIZE_TBL
WHERE STOCK_MANAGEMENT_TYPE = '1';