/ Published in: SQL

The inner join could be nested too
Expand |
Embed | Plain Text
UPDATE revisions AS target INNER JOIN (SELECT revision_id AS rev_id, id AS f_id FROM tmp2) AS source ON target.id = source.rev_id SET target.file_de_id = source.f_id;
You need to login to post a comment.