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

6 votes173 views4 answers
Mysql group by month
SQL
2 votes185 views2 answers
Oracle create table if not exists
SQL
0 vote122 views1 answer
Check if due date is less than todays date sql
SQL
-1 vote167 views1 answer
Module operator in oracle sql
SQL
1 vote189 views1 answer
Sql group by sum with condition
SQL
0 vote173 views1 answer
Docker open terminal mysql server
SQL
7 votes168 views1 answer
Safe update mysql
SQL
14 votes187 views6 answers
Auto_increment mysql
SQL
10 votes179 views5 answers
Mysql create user
SQL
1 vote168 views2 answers
Sql now - 1 day
SQL