title: looking for way to delete fragments from not existing data
body: <p>I have following tables</p>
  
  <pre><code>report_pre    { id, date}
  report_sections   {id,report,data}
  </code></pre>
  
  <p>I want to delete table fragments with following sql code:-</p>
  
  <pre><code>DELETE
  FROM
  report_sections
  WHERE
  report=ANY(
      SELECT 
          rs.report 
      FROM 
          report_sections rs 
      WHERE 
          NOT EXISTS (
              SELECT
                  rp.id
              FROM
                  report_pre rp
              WHERE
                  rp.id=rs.report
          )
  )
  </code></pre>
  
  <p>But I get the message:</p>
  
  <blockquote>
    <p>#1093 - You can't specify target table 'report_sections' for update in FROM clause</p>
  </blockquote>
  
  <p>What am I doing wrong?
  I tried it already different ways, but found no solution so far.
  Please help.</p>