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