我有一个下面的查询,但它不起作用。我做错了什么?这个可能吗?
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'
我有一个下面的查询,但它不起作用。我做错了什么?这个可能吗?
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'
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';
UPDATE ProductReviews
SET ProductReviews.status = '0'
FROM ProductReviews
INNER JOIN products
ON ProductReviews.pid = products.id
WHERE ProductReviews.id = '17190'
AND products.shopkeeper = '89137'
FROM ProductReviews AS pr
和 SET status = '0'
替换为 ProductReviews.status = '0'
,已经修复了它。 - Johhan Santana