advanced code snippet search

Posted By

sveggiani on 02/24/10


Tagged


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

Tyster


Update table with data from a (pseudo) join

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. UPDATE documents_logs, documents, documents_types
  2. SET documents_logs.document_company_id = documents_types.company_id
  3. WHERE documents.id = documents_logs.document_id AND documents_types.id = documents.documents_type_id

Report this snippet  

You need to login to post a comment.