1.update id set (a,b,c)=(select a,b,c from ida where ida.id=id.id);
2.update id t1 set a=(select t2.a from ida t2 where t1.id=t2.id),b=(select t2.b from ida t2 where t1.id=t2.id),c=(select t2.c from ida t2 where t1.id=t2.id)
UPDATE tz_main SET (A,B,C)=(select A,B,C from tz_main where id=''xxxxxx) WHERE id='xxxxxxx'
UPDATE RMP_BUSINESSINFO RBI SET (COORDINATE_NAME) = (SELECT CONTACT_ADDRESS FROM RMP_BUSINESSINFO RB WHERE RBI.BUSINESS_ID = RB.BUSINESS_ID)