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

20 votes207 views6 answers
Mysql reset auto increment
SQL
4 votes294 views1 answer
Select first and last row sql
SQL
10 votes294 views2 answers
Doublon sql
SQL
10 votes143 views1 answer
Oracle view dependencies
SQL
0 vote238 views1 answer
Retornar apenas o ano mysql date
SQL
0 vote198 views1 answer
Can't connect to postgresql mac os
SQL
17 votes262 views2 answers
How to assign date field for table in mysql
SQL
0 vote280 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote209 views1 answer
Php select data from mysql database without column name
SQL
1 vote211 views1 answer
Sql server update column based on another table
SQL