select
    item_code as ITEM,
    item_name as I_NAME,
    cl_name as C_NAME,
    size_name as S_NAME
from
    color_tbl
cross join
    item
cross join
    size_tbl
where
    stock_management_type == 1
order by
    item_code asc,
    cl_code asc,
    size_code asc;