select a.ITEM_CODE as ITEM, a.ITEM_NAME as I_NAME, b.CL_NAME as C_NAME, c.SIZE_NAME as S_NAME
from ITEM a
cross join COLOR_TBL b, SIZE_TBL c
where STOCK_MANAGEMENT_TYPE = 1
order by a.ITEM_CODE, b.CL_CODE, c.SIZE_CODE;