SQL Server-更新时的内部联接

Question

我有下面的查询不起作用。我究竟做错了什么？这有可能吗？

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 RINNER JOIN dbo.products AS P        ON R.pid = P.id WHERE R.id = '17190'   AND P.shopkeeper = '89137';