mysql - How to join two tables in an UPDATE statement? - Stack ...

You're on the right track, but you need to specify a JOIN between the tables: UPDATE tweets JOIN users ON tweets.user_id = users.user_id SET ...

www.google.com.tw