SQL Server - inner join when updating [duplicate]

Question

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' 

Answer 1

UPDATE R  SET R.status = '0'  FROM dbo.ProductReviews AS R INNER JOIN dbo.products AS P         ON R.pid = P.id  WHERE R.id = '17190'    AND P.shopkeeper = '89137'; 

Answer 2

This should do it:

UPDATE ProductReviews SET    ProductReviews.status = '0' FROM   ProductReviews        INNER JOIN products          ON ProductReviews.pid = products.id WHERE  ProductReviews.id = '17190'        AND products.shopkeeper = '89137'