SELECT
	ITEM_CODE AS ITEM,
	ITEM_NAME AS I_NAME,
	CL_NAME AS C_NAME,
	SIZE_NAME AS S_NAME	
FROM
	ITEM, SIZE_TBL, COLOR_TBL
WHERE
	STOCK_MANAGEMENT_TYPE = 1
ORDER BY
	ITEM_CODE,
	CL_CODE,
	SIZE_CODE