Mysql 关联多表并更新表操作
update instock as s inner join (select sc.sale_channel_name, scsh.store_house_id as idfrom sale_channel as scleft join sale_channel_store_house scsh on sc.sale_channel_id = scsh.sale_channel_id) as t on s.store_id = t.idset s.label = t.sale_channel_na
原创
2021-10-07 17:05:02 ·
169 阅读 ·
0 评论