select ITEM_CODE, ITEM_NAME, CL_NAME, SIZE_NAME
from ITEM
cross join COLOR_TBL
cross join SIZE_TBL
where STOCK_MANAGEMENT_TYPE = 1
order by ITEM_CODE, CL_CODE, SIZE_CODE;