zcwdsada的博客

update instock as s inner join (select sc.sale_channel_name, scsh.store_house_id as id from sale_channel as sc left join sale_channel_store_house scsh on sc.sale_channel_id = scsh.sale_channel_id) as t on s.store_id = t.id set s.label = t.sale_channel_na