advanced code snippet search

Posted By

ChrisCantley on 08/11/10


Tagged

update


Versions (?)

Who likes this?

4 people have marked this snippet as a favorite

hchattaway
mprabhuram
ljayz
Tyster


Update one table from another

 / Published in: SQL
 
Expand | Embed | Plain Text 
  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  

You need to login to post a comment.