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)
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)