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 R

INNER JOIN dbo.products AS P 

       ON R.pid = P.id 

WHERE R.id = '17190' 

  AND P.shopkeeper = '89137';