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

1 vote127 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
2 votes122 views3 answers
How to pass password mysql command line
SQL
6 votes132 views4 answers
Remove spaces sql server
SQL
0 vote118 views1 answer
Oracle list index on table
SQL
0 vote178 views1 answer
Postgres dump sql insert
SQL
0 vote124 views1 answer
How to select only a certain date sql
SQL
2 votes134 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
1 vote124 views1 answer
Sql server datetime vs datetime2
SQL
1 vote140 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
1 vote139 views1 answer
Sqlite update from another table
SQL