第一种方法:
1 update tinfo2 set tinfo2.remark = tinfo1.remark 2 from tinfo1 inner join tinfo2 on tinfo1.name = tinfo2.name
第二种方法(oracle):
MERGE INTO tebale1 A USING (SELECT * FROM tebale1 ) b ON (A.CUACCT_CODE = B.CUACCT_CODE AND A.INST_SNO = B.INST_SNO) WHEN MATCHED THEN UPDATE SET A.INST_BAL = B.INST_BAL WHERE A.INST_BAL <> B.INST_BAL
标签:CODE,tinfo2,tinfo1,表的值,字段,INST,SQL,BAL From: https://www.cnblogs.com/mumianhuasayyes/p/16739427.html