Update A1
SET A1.address1 = upper(B1.address1) ,
A1.address2 = upper(B1.address2),
A1.city = upper(B1.city),
A1.state = upper(B1.state)
from xupaddress A1, xupaddress as B1
where A1.ProfileID = B1.ProfileID