SQL Server 2017

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

CREATE TABLE #tbl1 (
id int identity(1,1) PRIMARY KEY CLUSTERED,
words VARCHAR(30) NOT NULL);

CREATE TABLE #tbl2 (
id int identity(1,1) PRIMARY KEY CLUSTERED,
words VARCHAR(30) NOT NULL);

INSERT INTO #tbl1 (words)
SELECT 'a'
UNION ALL
SELECT 'b'
UNION ALL
SELECT 'c'
UNION ALL
SELECT 'd'
UNION ALL
SELECT 'e'

INSERT INTO #tbl2 (words)
SELECT 'aa'
UNION ALL
SELECT 'bb'
UNION ALL
SELECT 'cc'
8 rows affected

UPDATE T1
SET T1.words = t2.words
FROM #tbl1 T1
INNER JOIN #tbl2 T2 ON t1.id = t2.id
3 rows affected

SELECT * FROM #tbl1


id
words


1
aa

2
bb

3
cc

4
d

5
e