Performing a MySQL UPDATE with multiple JOINs

Question

I have the following query that works...

SELECT u.route_id, g.route_id
FROM user_route u
JOIN user_address a ON a.address_id = u.route_begin_id
JOIN user_address b ON b.address_id = u.route_finish_id
JOIN google_route g ON g.route_begin_id = a.address_google_id 
AND g.route_finish_id = b.address_google_id

But I would like to update u.google_route_id with g.route_id's value

Can anyone suggest how I go about this, thanks.

possible duplicate of [mysql update join](http://stackoverflow.com/questions/15209414/mysql-update-join) — sgeddes, Dec 10 '14 at 20:07

score 0 · Answer 1 · edited Dec 10 '14 at 20:13

0

update user_route u
JOIN user_address a ON a.address_id = u.route_begin_id
JOIN user_address b ON b.address_id = u.route_finish_id
JOIN google_route g ON g.route_begin_id = a.address_google_id 
AND g.route_finish_id = b.address_google_id)
set u.google_route_id=g.route_id

edited Dec 10 '14 at 20:13

Gordon Linoff

1,242,037
58
646
786

answered Dec 10 '14 at 20:10

jdog

2,465
6
40
74

Performing a MySQL UPDATE with multiple JOINs

1 Answers1