SQL Server – inner join when updating [duplicate]

I have the below query which does not work. What am I doing wrong? Is this even possible?

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"