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

2 votes232 views1 answer
Sql find not in list
SQL
2 votes253 views1 answer
Postgresql group by month and year
SQL
3 votes210 views1 answer
Oracle revoke
SQL
1 vote211 views1 answer
Psql connections
SQL
3 votes211 views2 answers
WhereIn SQL
SQL
1 vote211 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
4 votes194 views2 answers
Oracle set date format
SQL
0 vote221 views1 answer
Reset postgresql password windows
SQL
3 votes279 views1 answer
Mysql cli connect with password
SQL
0 vote226 views1 answer
MySQL get all previous date record
SQL