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 SIZE_TBL s cross join COLOR_TBL c
where i.STOCK_MANAGEMENT_TYPE = '1'
ORDER BY ITEM_CODE, CL_CODE, SIZE_CODE;