求一更新语句

[笑容为你]

表1 tb_object
objectid int
version int

表2 tb_value
id int
objectid int
version int

要求tb_value的version 更新 为tb_object的version ，条件是tb_value.objectid == tb_object.objectid

[笑容为你]

update tb_value v,tb_object o set v.version = o.version where v.object_id = o.object_id;

[百年树人]

update v
set v.version = o.version 
from tb_value v,tb_object o 
where v.object_id = o.object_id;