title: MySQL: delete from IN
body: <p>I know this is a simple syntax issue.  Trying to delete all users from a subquery:</p>
  
  <pre><code>delete from users
  where id IN (
  
  select u.id
  from users u 
  where not exists (select * from stickies i where i.user_id = u.id) 
  group by u.email 
  having count(*) &gt; 1
  
  )
  </code></pre>
  
  <p>Getting this error:</p>
  
  <pre><code>error : You can't specify target table 'users' for update in FROM clause
  </code></pre>
  
  <p>The subquery works fine (returns list of user id's).</p>