SQL Server - 更新[重复]时的内部联接-Java 学习之路

300

这个问题在这里已有答案：

Update a table using JOIN in SQL Server? 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'

2 回答

663

这应该这样做：

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

回复于 2024-04-29T07:15:53+08:00

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

回复于 2024-04-29T07:15:53+08:00

SQL Server - 更新[重复]时的内部联接

2 回答

相关问题