title: Delete - I can't specify target table?
body: <p>Why this query doesn't work?</p>
  
  <pre><code>DELETE FROM recent_edits 
  WHERE trackid NOT IN 
       (SELECT DISTINCT history.trackid 
       FROM history JOIN recent_edits ON history.trackid=recent_edits.trackid 
       GROUP BY recent_edits.trackid)
  </code></pre>
  
  <p>I get this message : "You can't specify target table "recent_edits" for update in FROM clause</p>