Sql Server - Inner Join When Updating [Duplicate]

Name: Sql Server - Inner Join When Updating [Duplicate]
Uploaded: 2026-09-27T10:28:25+00:00
Duration: 13 min 25 s
Description: I Have the Below Query Which Does Not Work. What Am I Doing Wrong? Is This Even Possible? Update Productreviews as R Inner Join Products as P on R. Pid = P. Id...

Question

I have the below query which does not work. What am I doing wrong? Is this even possible?

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'

Accepted Answer

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

Answer 2

This should do it:

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

Sql Server - Inner Join When Updating [Duplicate]

Must Read

2 Answers

Sophia Al-Mansoor