根据另一个表数据更新到指定表

mssql

  UPDATE Test_BR SET Test_BR.VERSION =  Test_BR2.VERSION2  FROM Test_BR2  inner join Test_BR   on Test_BR.code = Test_BR2.code2 

mysql

UPDATE table1
INNER JOIN table2 
on table1.id=table2.id 
set table1.remark=table2.name

oracle

MERGE INTO table1 t1
USING
 table2  t2
ON(t1.classname = t2.classname)
WHEN MATCHED THEN UPDATE SET
t1.remark = t2.remark