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

5 votes308 views1 answer
Oracle nls parameters
SQL
0 vote308 views1 answer
Oracle create package specification
SQL
0 vote319 views1 answer
Kill a pid redshift
SQL
1 vote312 views1 answer
Postgresql transaction discard all
SQL
1 vote326 views1 answer
Postgresql define pk sequence next number
SQL
0 vote335 views2 answers
Sql count number of rows after group by
SQL
3 votes303 views2 answers
Coalesce mysql
SQL
4 votes321 views1 answer
Mysql copy table with new name
SQL
17 votes332 views4 answers
Mysql remove ubuntu
SQL
-1 vote324 views1 answer
Partial search in sql
SQL