jueves, 18 de febrero de 2021

Update + Inner Join SQL Server

This is the correct way to update records by performing an inner join in SQLSRV:


UPDATE tbl1

SET tbl1.field1 = tbl2.field2

FROM table_name1 tbl1

INNER JOIN table_name2 tbl2 

ON tbl1.id = tbl2.id

WHERE ... 

No hay comentarios:

Publicar un comentario