title: How to use data in same table on UPDATE query?
body: <pre><code>update accounts set password=(select password from accounts where name='joongsu') 
  where id=(select accountid from characters where name='Nobless')
  </code></pre>
  
  <p>it doesn't work with error message "You can't specify target table 'accounts' for update in FROM clause"</p>
  
  <p>Why doesn't it work? select queries in above only return 1 row.</p>