title: How can I write this SQL-Statement correctly
body: <p>I want to make an uptate to a table with thee following Statement:</p>
  
  <pre><code>UPDATE plz_buland_kreis SET KFZKZ='A' 
  WHERE Kreis IN ( SELECT kreis FROM plz_buland_kreis WHERE Kreis LIKE 'Augsburg%' )
  </code></pre>
  
  <p>I get the following error:</p>
  
  <blockquote>
    <p>MySQL meldet:   1093 - Table 'plz_buland_kreis' is specified twice,
    both as a target for 'UPDATE' and as a separate source for data</p>
  </blockquote>
  
  <p>Is it possible to write this SQL-Statement correctly?</p>