BEGIN
FOR c IN 
(
select distinct t2.name,t1.id
from table1 t1,
table2 t2
where t1.id = t2.id
)
LOOP
update table1 set name = c.name 
where id = c.id;
END LOOP;
END;