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 vote324 views1 answer
Update database collation in postgresql
SQL
0 vote373 views1 answer
Insert query return id mysql
SQL
1 vote335 views3 answers
Sql server get week dates from week number
SQL
0 vote334 views1 answer
Lost connection to mysql
SQL
0 vote312 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote331 views1 answer
Add computed column to table sql server
SQL
0 vote325 views2 answers
Transaction php
SQL
9 votes350 views3 answers
Date format in sql
SQL
0 vote339 views1 answer
Alter check command
SQL
2 votes325 views1 answer
Oracle convert run_duration to number
SQL