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

11 votes235 views3 answers
Change column name sql server management studio
SQL
0 vote257 views2 answers
Sql day from datetime
SQL
1 vote235 views1 answer
Pv mysql import
SQL
0 vote244 views1 answer
Sql find all different values in column
SQL
1 vote237 views1 answer
Sql server kill all connections
SQL
0 vote242 views4 answers
How to connect form to database
SQL
0 vote247 views1 answer
Hibernate show sql xml property
SQL
1 vote236 views1 answer
Postgres delete from where date is greater than specific date
SQL
1 vote230 views2 answers
Mysql join two tables
SQL
1 vote232 views1 answer
User privileges postgresql information_schema
SQL