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