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 vote667 views1 answer
Sql field equals multiple values
SQL
2 votes310 views2 answers
Sql query to copy data from one column to another
SQL
0 vote292 views1 answer
Heidisql check how much space a row
SQL
0 vote295 views1 answer
Postgresql regular expression special characters
SQL
0 vote301 views1 answer
Mysqldump ignore table
SQL
1 vote315 views1 answer
Oracle check table lock
SQL
1 vote300 views1 answer
Postgresql contains
SQL
5 votes304 views4 answers
Rollback to in sql
SQL
11 votes326 views1 answer
Creating tables in sql with python
SQL
0 vote303 views2 answers
Jsonb
SQL