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 vote194 views1 answer
Compression of dabatase mysqldumo
SQL
2 votes228 views3 answers
Sql server reseed identity column
SQL
0 vote177 views1 answer
Mysql shell ERROR: Not connected.
SQL
2 votes192 views2 answers
Change mysql password from command line
SQL
3 votes182 views1 answer
Sql server check version
SQL
0 vote186 views1 answer
Java sql timestamp now
SQL
23 votes170 views6 answers
How to create table in sql
SQL
1 vote204 views3 answers
Sql procedure
SQL
0 vote202 views1 answer
Including parameters in OPENQUERY
SQL
0 vote183 views4 answers
How to drop all tables in sql
SQL