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

31 votes136 views2 answers
Grant all priviledges to mysql user
SQL
1 vote149 views3 answers
Sql procedure
SQL
3 votes137 views1 answer
Sql online test questions and answers
SQL
5 votes128 views3 answers
Mysql check if null or empty string
SQL
1 vote121 views2 answers
How to check username in mysql command line
SQL
0 vote130 views1 answer
Sql alter table order by
SQL
6 votes140 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote220 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote137 views1 answer
Ms sql filter all sympbol
SQL
0 vote163 views1 answer
Postgres truncate with cascade
SQL