title: MySQL delete with nested select query
body: <p>I have the following MySQL query:</p>
  
  <pre><code>DELETE FROM catalogue 
  WHERE catalogue_id IN (
    SELECT catalogue_id 
    FROM catalogue 
    WHERE (
      product_id = (SELECT product_id FROM catalogue WHERE catalogue_id = '2290') 
      AND length_id = (SELECT length_id FROM catalogue WHERE catalogue_id = '2290') 
      AND gauge_id = (SELECT gauge_id FROM catalogue WHERE catalogue_id = '2290')
    )
  )
  </code></pre>
  
  <p>But when I attempt to execute I get the following error message:</p>
  
  <blockquote>
    <p>You can't specify target table 'catalogue' for update in FROM clause</p>
  </blockquote>
  
  <p>Could someone advise on where I'm going wrong?</p>