Joining Update query

Hi
I have a number of queries like this
UPDATE duration_events b
JOIN meteor_events p
ON p.event_id = b.event_id
SET b.image = p.image;
and
UPDATE duration_matched b
JOIN meteor_events p
ON p.event_id = b.event_id
SET […]

See original post by invalid@example.com (johnberman)