select
	ITEM_CODE as ITEM
	, ITEM_NAME as NAME
	, CL_NAME as C_NAME
	, SIZE_NAME as S_NAME
from ITEM, COLOR_TBL, SIZE_TBL
where STOCK_MANAGEMENT_TYPE = 1
order by ITEM_CODE, CL_CODE, SIZE_CODE;