title: SQL Server - inner join when updating
body: <p>I have the below query which does not work. What am I doing wrong? Is this even possible?</p>
  
  <pre><code>UPDATE ProductReviews AS R 
     INNER JOIN products AS P 
         ON R.pid = P.id 
  SET R.status = '0' 
  WHERE R.id = '17190' 
    AND P.shopkeeper = '89137'
  </code></pre>