UPDATE tb1,tb2 SET tb1.address=tb2.address WHERE tb1.name=tb2.name
UPDATE
tb1,tb2
SET
tb1.address=tb2.address
WHERE
tb1.
name
=tb2.