SQL multi-table join query statement

This article will show you the results of multi-table join queries in mssqlserver. If you need it, please refer to it.

This article will show you the results of multi-table joint query in mssql server. If you need it, please refer to it.

# Temptest1 # temptest2

The implementation method is as follows:

The Code is as follows:
Update t1 Set t1. age = t2.age From # temptest1 t1 Join # temptest2 t2 On t1.id = t2.id (Supplement) SQL Server 2008 Merge command syntax: Merge into # temptest1 t1 Using (age, id from # temptest2) t2 On t1.id = t2.id When matched then Update set t1.age = t2.age