SQLServerでjoinをともなう構文

UPDATE FROM JOIN

UPDATEの直後にJOINではなく、FROMを書いてJOIN

UPDATE table1
SET
  value = t2.value
FROM table1 as t1
  INNER JOIN table2 as t2
  ON t1.Key = t2.Key