UPDATE T1
SET A1 = B.B1,
A2 = B.B2,
A3 = B.B3
FROM T1 AS A INNER JOIN T2 AS B
ON (A.ID = B.ID)
UPDATE T1
SET A1 = B.B1,
A2 = B.B2,
A3 = B.B3
FROM T1 AS A INNER JOIN T2 AS B
ON (A.ID = B.ID)