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 vote190 views1 answer
Find a column in all tables postgres
SQL
0 vote178 views1 answer
Get number of table colums in sql query
SQL
0 vote175 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote137 views1 answer
Mysql convert column to uppercase
SQL
17 votes192 views3 answers
How to change a collumn name in sql
SQL
18 votes205 views3 answers
Mysql add column default value
SQL
0 vote173 views1 answer
Oracle list chain steps
SQL
1 vote209 views4 answers
How to check table in postgresql from terminal
SQL
0 vote187 views1 answer
Mysql command prompt date insert format
SQL
0 vote185 views1 answer
Pip install mysqlclient error
SQL