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 vote350 views2 answers
Update information in a mysql column
SQL
0 vote346 views2 answers
Psql commande \gset
SQL
4 votes331 views4 answers
Update select mysql
SQL
1 vote338 views1 answer
Postgresql delete cascade
SQL
1 vote348 views3 answers
Rename table snowflake
SQL
0 vote330 views1 answer
Sql server port 1434
SQL
2 votes333 views1 answer
Sql count having
SQL
20 votes328 views4 answers
Reset auto increment in MySQL
SQL
3 votes319 views2 answers
Oracle for loop
SQL
3 votes326 views2 answers
Oracle synonym
SQL