Return to Snippet

Revision: 50631
at August 29, 2011 22:34 by preasha


Initial Code
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;

Initial URL


Initial Description
The inner join could be nested too

Initial Title
Update table with values selected in a subquery

Initial Tags
sql, table, update

Initial Language
SQL