修改A表中某字段为B表中id相同的数据对应的字段

UPDATE A SET A.phone = B.phone FROM TestA A JOIN TestB B ON A.ID = B.ID