关于匹配条件更新字段值的问题update info iset i.saler i.saler * (select s.values from scale s wher
关于匹配条件更新字段值的问题
update info i set i.saler = i.saler * ( select s.values from scale s where s.infoid = i.id) where exists (select o.id from info o )
??
结果：
idnamesaler1张三15002王五6000?
?
?
?