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

17 votes274 views6 answers
Sql current date
SQL
0 vote300 views1 answer
Oracle running queries
SQL
-1 vote314 views3 answers
PS5
SQL
9 votes305 views4 answers
Mysql set id auto increment
SQL
1 vote288 views1 answer
Mariadb case switch
SQL
0 vote272 views1 answer
Sql select column names starting with
SQL
3 votes272 views1 answer
Show index table
SQL
5 votes311 views4 answers
Upload database mysql command line
SQL
2 votes274 views2 answers
Set database timezone mysql
SQL
0 vote294 views1 answer
Run mysql xampp shell
SQL