Update SQL statements with One-to-multiple table fields

One-to-multiple table Field update SQL statement table T_A www.2cto.com id name1 Zhang weisan 2 LITH table T_ B id name1 zhangs1 zsan1 zs2 lisi2 ls www.2cto.com objective: change the name of the record corresponding to the id in Table T_ B and the id in Table T_A to be consistent with the name in Table T_A. As follows: id name1 Zhang San 1 Zhang San 1 Zhang San 2 Li Si 2 Li Si Execute SQL: UPDATE T_ B SET (NAME, ID) = (select name, id from (SELECT T_ B .ROWID RD, T_A.NAME, t_A.ID FROM T_A, T_ B WHERE T_A.ID = T_ B .ID) tmp where T_ B .ROWID = TMP. RD );