关于匹配条件更新字段值的问题
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 )
??
结果:
?