Answers for "SQL UPDATE with inner join updates joined table"

update with inner join

UPDATE tb1
SET tb1.column_1 = tb2.column_1
FROM table_1 AS tb1
INNER JOIN table_2 AS tb2
ON tb1.column_2 = tb2.column_3

Posted by: Guest on January-21-2021

SQL update with join

UPDATE D
SET D.Name = 'Computer Science and Engineering'
FROM Department D
INNER JOIN Student S ON D.Id = S.DepartmentId

Posted by: Guest on July-09-2021

Code answers related to "SQL UPDATE with inner join updates joined table"