SELECT
	ITEM_CODE AS ITEM,
	ITEM_NAME AS I_NAME,
	CL_NAME AS C_NAME,
	SIZE_NAME AS S_NAME
FROM
	ITEM I
	CROSS JOIN COLOR_TBL C
	CROSS JOIN SIZE_TBL S
WHERE
	I.STOCK_MANAGEMENT_TYPE = 1
ORDER BY
	ITEM_CODE,
	CL_CODE,
	SIZE_CODE
	;