 <p>The correct MySQL syntax is:</p> <pre><code>UPDATE allranks ar INNER JOIN therankings r on ar.`Player Name` = r.`Player Name` SET ar.Ranktwo = r.Rank; </code></pre> <p>Notice how the table aliases make the query easier to write and to read.</p>