title: SQL - #1093 - Table '' is specified twice, both as a target for 'UPDATE' and as a separate source for data
body: <p>I have this code:</p>
  
  <pre><code>UPDATE WORLD_TEST 
  SET PROGRAMMER = (SELECT (RECURSE_HOUR/360) 
                    FROM WORLD_TEST_PROGRAMMER, WORLD_TEST 
                    WHERE LVL = LVL_PROGRAMMER) 
  WHERE (SELECT MAX_RECURSE 
         FROM WORLD_TEST_PROGRAMMER, WORLD_TEST 
         WHERE LVL = LVL_PROGRAMMER) 
  &gt;= 
  (PROGRAMMER+(SELECT (RECURSE_HOUR/360) 
               FROM WORLD_TEST_PROGRAMMER, WORLD_TEST 
               WHERE LVL = LVL_PROGRAMMER));
  </code></pre>
  
  <p>With this error:</p>
  
  <blockquote>
    <p>1093 - Table 'WORLD_TEST' is specified twice, both as a target for 'UPDATE' and as a separate source for data</p>
  </blockquote>
  
  <p><strong>EDIT (clarification from comments):</strong> <code>PROGRAMMER</code> and <code>LVL_PROGRAMMER</code> is from <code>WORLD_TEST</code> table, and <code>RECURSE_HOUR</code>, <code>LVL</code>, <code>MAX_RECURSE</code> is from <code>WORLD_TEST_PROGRAMMER</code> table.</p>