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

12 votes142 views1 answer
How to change the value of a table in sql
SQL
0 vote151 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
0 vote146 views4 answers
How to get max salary in each department in sql
SQL
0 vote141 views1 answer
How to install mysql without admin rights
SQL
3 votes165 views1 answer
Set default today mysql
SQL
0 vote179 views1 answer
Sql declare variable single line
SQL
7 votes137 views1 answer
Oracle set sequence value to max(id)
SQL
1 vote138 views1 answer
Oracle rolling back transactions
SQL
10 votes150 views2 answers
Forgot my mysql password mac
SQL
5 votes134 views1 answer
Postgres integer to serial
SQL