title: Why update and select both is not working with same table
body: <p>In this query i want to update those records which is latest posted.But my this query is not working please help me what the reason ???</p>
  
  <p>Error :--You can't specify target table 'beevers_products' for update in FROM clause   </p>
  
  <pre><code>update beevers_products set product_name='my_product_name' where posted_date in (SELECT posted_date FROM `beevers_products` order by posted_date asc limit 1)
  </code></pre>