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

2 votes267 views2 answers
How to create an empty table from an existing table
SQL
9 votes276 views4 answers
Mysql set id auto increment
SQL
1 vote265 views1 answer
Mysql stop password policy
SQL
0 vote271 views1 answer
Update and keep original value sql
SQL
1 vote267 views1 answer
Sql server insert into temp table
SQL
0 vote267 views1 answer
Sql replace id with name from another table
SQL
51 votes579 views6 answers
Installing mysql on ubuntu
SQL
11 votes271 views1 answer
Get ddl materialized view oracle
SQL
0 vote208 views1 answer
Sqlalchemy existing database
SQL
0 vote301 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL