SQL multi-table join query statement

# Temptest1 # temptest2

   

The implementation method is as follows:

The code is as follows:	Copy code
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 (select age, id from # temptest2) t2 On t1.id = t2.id When matched then Update set t1.age = t2.age