merge into tableA a
using(
  
 SELECT  a,b,c from tableB
) b 
on (a.id = b.id)//这里一定要用括号包起来....
 when matched then
update set 
a.a=b.a, 
a.b= b.b, 
a.c= b.c