Sql Update Query [duplicate]

Question

This question already has answers here:

How do I UPDATE from a SELECT in SQL Server? (33 answers)

Closed 7 years ago.

I have a table T1 which contains three columns: Id, Name, Address

There is another table T2 which contains 2 columns Id, New_Address. Id column of T2 is same as of T1.

I need a query which will update Address column of T1 with New_Address of T2.

I can do it through a loop by checking ID and executing update statement. How can it has to be done with a query?

Answer 1

How about

UPDATE T1
SET Address = T2.New_Address
FROM T2
WHERE T1.id = T2.id

Answer 2

UPDATE T1
SET T1.Address = T2.New_Address
FROM T1
INNER JOIN T2 ON T2.ID = T1.ID

Answer 3

UPDATE T1
SET Address = (select New_Address from T2 where T1.ID=T2.ID );