Update one table from another


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



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.