Advanced Search

Update one table from another

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1.  
  2.  
  3. UPDATE t1
  4. SET col2 = t2.col2
  5. FROM table1 t1 
  6. INNER JOIN table2 t2
  7. ON t1.col1=t1.col2
  8. WHERE Col3 >5
  9.  

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.