Update from Select Query

Create Table TestUpdate
(
TranId int identity (1,1),
Val1 int,
Val2 Int,
Val3 Int
)


Insert into TestUpdate  values(1,2,1)



Update TestUpdate set Val3 = 4 from TestUpdate where val2 = 2