UPDATE table_one a INNER JOIN table2 b on ... The syntax looks correct to me. If you do a SELECT ...
stackoverflow.com