SyntaxFix
Write A Post
Hire A Developer
Questions
You can use alias to improve the query:
UPDATE t1 SET t1.Value = t2.Value FROM table1 AS t1 INNER JOIN table2 AS t2 ON t1.ID = t2.ID