join - MySql Update A Joined Table - Stack Overflow

You have the ordering of the statements wrong. You can read up on the syntax here (I know, it's pretty hard to read. UPDATE tableA a JOIN tableB b ...

www.google.com.tw