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

1 vote261 views2 answers
Install mysqldump ubuntu
SQL
37 votes417 views3 answers
Sql check duplicate value in column
SQL
0 vote265 views1 answer
How to get data from 2 database
SQL
1 vote280 views1 answer
Connect to mysql database ubuntu
SQL
0 vote258 views1 answer
Basic structure of sql expression having clause
SQL
2 votes237 views1 answer
Convert series number to date in sql
SQL
1 vote269 views1 answer
Oracle enable job
SQL
16 votes251 views6 answers
Insert sql
SQL
17 votes258 views3 answers
Postgresql version command
SQL
0 vote251 views1 answer
IS THEre any difference between using default and := in plsql
SQL