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 vote159 views1 answer
If column value is null then in mysql
SQL
0 vote200 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
0 vote197 views1 answer
Sqlite trim
SQL
5 votes167 views1 answer
Oracle add time to date
SQL
20 votes170 views5 answers
Reset auto increment mysql
SQL
0 vote147 views1 answer
Mysql show category once count how many products
SQL
0 vote152 views1 answer
Soql update query
SQL
5 votes176 views2 answers
Get columns number sql
SQL
0 vote159 views1 answer
Joins vs includes
SQL
0 vote164 views1 answer
Mysql get first 2 characters of string
SQL