update address set Add2 = partymast.Add2,Add3 = partymast.Add3
from address inner join PartyMast on address.PartyMastId = partymast.PartyMastId