Use update inner join and delete inner join (zt) in SQL)

This article is reproduced in SQL using update inner join and delete inner join.

Because the Update Connection statement is required when processing data in the project, the update inner join syntax is used. Here we repost the statement for future search. Thanks to the original author.

The update XXX set XXX Where statement is well known. Only then can we find that update and delete support the inner join update method, which is amazing. Sample Code of the Sharing Section:

 
 

  
  
 
   
 
    
12345
 
    
update tb_User set pass=''from tb_User usr inner join tb_Address addr on usr.nAddressFK = addr.nAddressID where usr.id=123
 
   
 
  
 
 

The update format is

Update T1 set t1.name = 'liu'From T1Inner join T2 on t1.id = t2.tid

The delete statement is similar

Delete from T1From T1Inner join T2 on t1.id = t2.tid

Note:Blue.

 
 

  
  
 
   
 
    
12345
 
    
update tb_User set pass=''from tb_User usr inner join tb_Address addr on usr.nAddressFK = addr.nAddressID where usr.id=123
 
   
 
  
 
 

The update format is

Update T1 set t1.name = 'liu'From T1Inner join T2 on t1.id = t2.tid

The delete statement is similar

Delete from T1From T1Inner join T2 on t1.id = t2.tid

Note:Blue.