sql-server - SQL Server - 更新时内连接

Question

这个问题已经有答案了:

Update a table using JOIN in SQL Server? (13 个回答)

已关闭 10 年前。

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

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';