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 vote364 views1 answer
Get enginge db mysql
SQL
0 vote350 views1 answer
Example of sql querry result sepapreted by comma
SQL
15 votes354 views3 answers
Create table with primary key auto increment in sql
SQL
2 votes392 views2 answers
How to add not null constraint in sql
SQL
9 votes365 views6 answers
Check constraint in sql
SQL
11 votes352 views4 answers
Round in sql
SQL
1 vote361 views1 answer
Mysql workbench in ubuntu 14.04
SQL
0 vote392 views1 answer
Learnxinyminutes sql
SQL
1 vote358 views2 answers
Changes not showing on website server odoo
SQL
0 vote388 views1 answer
How to write if case in select query in select statement
SQL