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 vote329 views1 answer
Add timestamp column to existing table t-sql
SQL
0 vote320 views1 answer
Mysql equivalent decode oracle
SQL
2 votes294 views3 answers
How to get second highest salary in each department in sql
SQL
17 votes321 views6 answers
What is cursor in sql server with example
SQL
0 vote376 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
0 vote317 views1 answer
Sql select upcoming birthdays
SQL
2 votes295 views2 answers
Checking data type in sql server
SQL
0 vote325 views1 answer
Oracle sql all days except weekends
SQL
2 votes338 views3 answers
How to check current user in mySQL
SQL
0 vote296 views1 answer
Sql server order by nulls last
SQL