title: Update where value is max from same table
body: <p>I'd like to do this.</p>
  
  <pre><code>update cart set productname='hey' where cartid=(select max(cartid) from cart)
  </code></pre>
  
  <p>However, the sql shows the error where the table 'cart' is defined twice. How do i get around this?</p>