UPDATE a_member A

  JOIN b_member B

    ON A.mb_id = B.mb_id

   SET A.mb_name=B.mb_name,

A.mb_nick=B.mb_nick,

A.mb_email=B.mb_email,

A.mb_homepage=B.mb_homepage

 WHERE A.mb_name="홍길동";