用表2的数据更新到表1
update 表1 set syncid=表2.syncid, syncdes =表2.syncdes ,
tablename =表2.tablename , keyfields =表2.keyfields ,
syncfields =表2.syncfields ,
serialno =表2.serialno from 表2
where 表1.syncid =表2.syncid
用表2的数据更新到表1
update 表1 set syncid=表2.syncid, syncdes =表2.syncdes ,
tablename =表2.tablename , keyfields =表2.keyfields ,
syncfields =表2.syncfields ,
serialno =表2.serialno from 表2
where 表1.syncid =表2.syncid