select
    i.ITEM_CODE as ITEM,
    i.ITEM_NAME as I_NAME,
    c.CL_NAME as C_NAME,
    s.SIZE_NAME as S_NAME
from
    item as i
inner join
    color_tbl as c
on
    i.update_user_name = c.update_user_name
inner join
    size_tbl as s
on
    i.update_user_name = s.update_user_name

where
    i.stock_management_type=1
order by
    i.item_code asc,
    c.cl_code asc,
    s.size_code asc;