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 vote173 views1 answer
Create sqlite database in laravel
SQL
1 vote179 views1 answer
Sql server loop over query
SQL
3 votes143 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
5 votes137 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
0 vote150 views1 answer
Mysql in clausule string array
SQL
0 vote146 views1 answer
Oracle sql generate list of days
SQL
0 vote150 views1 answer
Inserted row count tsql
SQL
0 vote178 views1 answer
Zsh: command not found: mysql mamp
SQL
0 vote160 views1 answer
Mysql drop vs delete
SQL
0 vote162 views2 answers
Replace null with 0 in sql
SQL