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 vote279 views1 answer
Criteria builder select subset of column
SQL
0 vote312 views1 answer
Default order by in mysql
SQL
1 vote293 views2 answers
Insert sqlite
SQL
1 vote328 views1 answer
Last 24 HOUR data in mysql
SQL
0 vote315 views1 answer
Make parameters nullable in sql server
SQL
9 votes283 views2 answers
Mysql change value
SQL
1 vote295 views1 answer
Ubuntu access database from terminal
SQL
18 votes266 views4 answers
Foreign key mySql
SQL
2 votes285 views1 answer
Oracle number to percentage
SQL
10 votes296 views1 answer
Oracle dependencies table
SQL