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_code asc, cl_code asc, size_code asc