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