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 vote141 views1 answer
Postgres meta command to show all rows in table
SQL
0 vote142 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
0 vote148 views1 answer
Mysql grouping functions
SQL
1 vote159 views1 answer
Sql sort column by date
SQL
4 votes142 views1 answer
Wilayah indonesia database
SQL
1 vote143 views1 answer
Mysql f# examples
SQL
5 votes135 views2 answers
Update all rows mysql
SQL
0 vote138 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
8 votes145 views2 answers
Sqlsrv default port
SQL
0 vote146 views2 answers
Sql trigger difference between for and after
SQL