title: update my join on temporary table
body: <p>I have a table called leaderboard </p>
  
  <p>which I create</p>
  
  <pre><code> create temporary table leaderboard 
   (
       rank integer primary key auto_increment, 
       score_id integer, 
       game varchar(65), 
       user_id integer
  )
  
  select 
       id, 
       highscore, 
       playername 
  from 
       players 
  order by 
       highscore desc
  </code></pre>
  
  <p>This is fine but am now trying to update the table with a join in the id.</p>
  
  <pre><code>UPDATE players 
  SET players.rank = leaderboard.rank 
  FROM players 
  JOIN leaderboard ON players.id = leaderboard.id
  </code></pre>
  
  <p>but get an error in the mysql? And pointers would be good</p>
  
  <p>error is</p>
  
  <blockquote>
    <p>...the right syntax to use near 'FROM players JOIN leaderboard ON
    players.id = leaderboard.id' at line 1</p>
  </blockquote>