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

11 votes187 views2 answers
Having clause
SQL
6 votes206 views2 answers
Postgresql restore from dump
SQL
2 votes269 views2 answers
Mysql write into table
SQL
17 votes331 views4 answers
Show all tables in oracle
SQL
0 vote259 views1 answer
Mysql subtract month from timestamp
SQL
0 vote268 views1 answer
Inner join distinct
SQL
2 votes200 views2 answers
Oracle multiple insert
SQL
0 vote206 views1 answer
Add unique constraint sql server multiple columns
SQL
7 votes252 views1 answer
Query delete duplicates
SQL
0 vote231 views1 answer
Permission denied postgres \copy csv command line
SQL