SQL Server - inner join when updating [duplicate]
UPDATE R SET R.status = '0' FROM dbo.ProductReviews AS RINNER JOIN dbo.products AS P ON R.pid = P.id WHERE R.id = '17190' AND P.shopkeeper = '89137';
This should do it:
UPDATE ProductReviewsSET ProductReviews.status = '0'FROM ProductReviews INNER JOIN products ON ProductReviews.pid = products.idWHERE ProductReviews.id = '17190' AND products.shopkeeper = '89137'