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 vote376 views3 answers
Postgresql get difference between two dates
SQL
0 vote348 views1 answer
Learn sqlite dart
SQL
2 votes370 views5 answers
Eloquest how to select one specific column in database
SQL
2 votes340 views2 answers
Sqlite_busy: database is locked
SQL
0 vote352 views1 answer
Mac os zsh: command not found: mysql
SQL
1 vote376 views1 answer
Oracle compile schema
SQL
0 vote368 views1 answer
Duplix print in Smartforms
SQL
1 vote351 views1 answer
Set all the vluses in calumn in sql to false
SQL
4 votes351 views2 answers
Show all database inside postgresql
SQL
5 votes370 views2 answers
Get number of columns sql
SQL