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

1 vote179 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
19 votes172 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote160 views1 answer
Clone table structure mysql
SQL
0 vote182 views1 answer
Mysql select inside sum
SQL
1 vote195 views3 answers
Reset sql primary key
SQL
0 vote171 views1 answer
Oracle INTERVAL DAY to second to number
SQL
0 vote191 views1 answer
Doesn't have default value mysql
SQL
6 votes177 views3 answers
Mysql server is not starting xampp
SQL
3 votes188 views1 answer
Oracle transaction commit rollback example
SQL
10 votes182 views4 answers
Fetch first 5 characters of the string in sql
SQL