SQL SERVER 中 UPDATE 与 INNER JOIN 结合的批量更新语句示例

参考 ： https://stackoverflow.com/a/9589124

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