SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT *
INTO dbo.Table1
FROM (VALUES(1,'A'),
            (2,'B'),
            (3,'C'),
            (4,'D'))V(ID,Value);

SELECT *
INTO dbo.Table2
FROM (VALUES(3,'E'),
            (4,'F'))V(ID,Value);
6 rows affected

SELECT *
FROM dbo.Table1;


ID
Value


1
A

2
B

3
C

4
D


UPDATE T1
SET [Value] = T2.Value
FROM dbo.Table1 T1
     JOIN dbo.Table2 T2 ON T1.ID = T2.ID;
2 rows affected

SELECT *
FROM dbo.Table1;


ID
Value


1
A

2
B

3
E

4
F


DROP TABLE dbo.Table1;
DROP TABLE dbo.Table2;