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 vote387 views1 answer
Recently updated stored procedure in sql server
SQL
8 votes349 views2 answers
Python simple connect to mysql
SQL
0 vote339 views1 answer
Criteria builder select subset of column
SQL
0 vote371 views1 answer
Connecting mySQL to STS
SQL
4 votes338 views1 answer
Oracle user tables
SQL
0 vote307 views0 answer
SQL
0 vote345 views1 answer
Docker open terminal mysql server
SQL
0 vote352 views4 answers
Mysql count table rows
SQL
0 vote553 views1 answer
Multiple row join
SQL
0 vote336 views1 answer
Where case insensitive like mysql
SQL