update spot s set s.name = (select ss.outername from spotregister ss where s.spotcode = ss.spotcode and ss.outername is not null),
s.outername = (select ss.outername from spotregister ss where s.spotcode = ss.spotcode and ss.outername is not null)
where s.spotcode in (select ss.spotcode from spotregister ss where s.spotcode = ss.spotcode and ss.outername is not null)
实现2个表的联合update
最新推荐文章于 2021-04-04 01:56:11 发布