Table A
address_id email
12341  aba@mail.com
12342  abb@mail.com
12343  abc@mail.com
12344  abd@mail.com
12345  abe@mail.com
12346  abf@mail.com
12347  abg@mail.com
12348  abh@mail.com
12349  abi@mail.com

Table B
address_id email
12342  xyz@mail.com
12344  xyy@mail.com
12349  xyx@mail.com

update TableA A set email=(select email from TableB B where A.address_id=B.address_id)