Update with inner join sql server

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

Source: stackoverflow.com

Update with inner join sql server

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

Source: stackoverflow.com

Similar codes

0 vote149 views1 answer
Multiple tricky query in sql server
SQL
1 vote143 views1 answer
Window function mysql
SQL
0 vote133 views1 answer
Sql cross apply vs join
SQL
1 vote151 views1 answer
Increase existing date in sql
SQL
0 vote133 views2 answers
Add new column after in sql
SQL
2 votes183 views1 answer
Mysql now format
SQL
4 votes191 views4 answers
Remove duplicate old value in mysql
SQL
0 vote180 views1 answer
Get initials name in sql
SQL
0 vote162 views1 answer
Show all mongodb
SQL
2 votes99 views1 answer
Mysql admin u root p password change password
SQL