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 vote183 views1 answer
Select password from user mysql
SQL
0 vote213 views1 answer
Procedures sql insert mysql
SQL
3 votes190 views1 answer
How to remove characters from string in mysql
SQL
0 vote181 views1 answer
Postgres add prefix to primary key
SQL
0 vote187 views1 answer
Deny select insert update delete sql
SQL
0 vote197 views1 answer
Mariadb alter table add column if not exists example
SQL
8 votes202 views2 answers
Oracle auto increment primary key
SQL
0 vote209 views1 answer
Sql statement show all emails with dome
SQL
1 vote201 views4 answers
Sequelize migration default value
SQL
0 vote197 views1 answer
Sql_inner_join
SQL