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 vote174 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
0 vote195 views1 answer
How to get parent and child record in single query using sql
SQL
1 vote210 views1 answer
Psql search table
SQL
0 vote172 views1 answer
How to save data in database in mysql node
SQL
0 vote200 views1 answer
UNION ALL LEFT JOIN
SQL
9 votes165 views4 answers
Mysql show table fields
SQL
2 votes170 views1 answer
Update trigger
SQL
1 vote150 views4 answers
Sql now
SQL
0 vote168 views1 answer
Sqlite3_open_v2
SQL
0 vote158 views1 answer
Mysql get 2nd value in comma separated list
SQL