Advanced Search

Update table with data from a (pseudo) join

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

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.