update from table.

UPDATE TA a SET name = b.name
FROM (SELECT id, name FROM TB) b
WHERE b.id = a.id;