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

0 vote116 views1 answer
Como hacer una consulta en sql
SQL
0 vote109 views1 answer
Mysql_num_fields in mysqli
SQL
1 vote107 views1 answer
Duplicating a MySQL table with all the data Command
SQL
0 vote116 views1 answer
Select even number id data from table
SQL
0 vote128 views1 answer
SELECT statement to find the specific cell in database table
SQL
4 votes66 views1 answer
And or sql order of operations
SQL
0 vote105 views1 answer
MySql Modify Increment
SQL
0 vote142 views1 answer
Postgres execute multiple sql file from command line
SQL
0 vote105 views1 answer
Oracle query archive mode
SQL
0 vote106 views1 answer
Sql count null as 0
SQL