title: update sql query where select max
body: <p>I want a query that updates the max number of the id... here is my code..</p>
  
  <pre><code>UPDATE `jobs` SET `sectors` = '12' WHERE `id` = (SELECT MAX(`id`) FROM `jobs`)
  </code></pre>
  
  <p>the error says : <code>#1093 - You can't specify target table 'wpjb_job' for update in FROM clause</code></p>
  
  <p>what can I do to make this happen?</p>