SELECT

	I.ITEM_CODE as ITEM,
	I.ITEM_NAME as I_NAME,
	C.CL_NAME as C_NAME,
	S.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 ASC,
	CL_CODE ASC,
	SIZE_CODE ASC