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