Update one table From another table with INNER JOIN in SQL

Declare @T1 Table(Eid int,Ename varchar(10))


Declare @T2 Table(Eid int,Ename varchar(10))

INSERT INTO @T1(Eid,EName)Values(1,'A')

INSERT INTO @T1(Eid,EName)Values(2,'B')

INSERT INTO @T1(Eid,EName)Values(3,'C')

INSERT INTO @T1(Eid,EName)Values(4,'D')

INSERT INTO @T1(Eid,EName)Values(5,'E')

SELECT * from @T1

INSERT INTO @T2(Eid,EName)Values(1,'R')

INSERT INTO @T2(Eid,EName)Values(2,'S')

INSERT INTO @T2(Eid,EName)Values(3,'T')

INSERT INTO @T2(Eid,EName)Values(4,'U')

INSERT INTO @T2(Eid,EName)Values(5,'V')

SELECT * from @T2



UPDATE a SET a.Ename = b.Ename

FROM @T1 a INNER JOIN @T2 b ON a.Eid = b.Eid

SELECT * FROM @T1