update test1 e1 set name=(select key from test2 e2 where e1.ID=e2.ID)
where ID in(select b.ID from (select * from test1) a join (select * from test2) b on a.ID=b.ID);
where ID in(select b.ID from (select * from test1) a join (select * from test2) b on a.ID=b.ID);