title: MySQL: You can't specify target table 'tasks' for update in FROM clause
body: <p>I have got MySQL error "You can't specify target table 'tasks' for update in FROM clause" running the following query:</p>
  
  <pre><code>DELETE FROM tasks
  WHERE tasks.id IN 
  (
  SELECT tasks.id
  FROM tasks 
      JOIN deadlines ON deadlines.id = deadline_id
  WHERE DATE_ADD(tasks.created_at, INTERVAL deadlines.duration DAY) &lt;= NOW()
  )
  </code></pre>
  
  <p>How can I manage this?</p>
  
  <p>Thanx!</p>