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

8 votes136 views1 answer
Oracle create datafile
SQL
4 votes137 views1 answer
Mac install mysql
SQL
4 votes139 views2 answers
REST API
SQL
1 vote161 views1 answer
Continue in sql
SQL
6 votes136 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote148 views1 answer
Sql server convert to guid
SQL
1 vote139 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
10 votes129 views6 answers
Mysql delete duplicates
SQL
0 vote137 views1 answer
Storing RGBA in mysql db
SQL
40 votes197 views6 answers
Update table mysql
SQL