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 vote183 views1 answer
Mysql server does not start mac
SQL
16 votes187 views3 answers
Delete row psql
SQL
0 vote195 views1 answer
Java sql timestamp now
SQL
25 votes226 views4 answers
Import mysql dump command line
SQL
5 votes195 views2 answers
Mysql drop table cascade
SQL
0 vote204 views1 answer
Mysql select where field is a value
SQL
25 votes203 views6 answers
Import mysql database command line
SQL
1 vote222 views4 answers
Aggregate function in sql
SQL
1 vote185 views1 answer
Xampp import sql file command line
SQL
2 votes197 views1 answer
Postgresql create schema in specific database
SQL