Answers for "how to update data from one table to another using sub query in sql server"

update sql server from another table

UPDATE t1
SET t1.column = t2.column
FROM Table1 t1 
INNER JOIN Table2 t2 ON t1.id = t2.id;

Posted by: Guest on October-18-2021

Code answers related to "how to update data from one table to another using sub query in sql server"