title: i am stuck with updates in mysql
body: <p>hey i have been working on mysql for a school project. i made an employee table and a kids table.but i get an error 'you cant specify target table for update in from clause' what i am trying to do is give 10% raise to all employees who have been working for more than 20 and have a kid. here is the code.</p>
  
  <pre><code>update employee
  set salary=salary*1.1
  where exists (
  select * from kids k,employee e where e.art=k.art and e.hire_date&lt;='1998-11- 
  16'); 
  </code></pre>
  
  <p>please help me guys :D</p>