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 vote256 views1 answer
Mysql trim characters
SQL
0 vote222 views1 answer
Sql select rows with simlar names
SQL
0 vote276 views2 answers
Postgres default user
SQL
0 vote264 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
0 vote253 views1 answer
Redirection 301 htaccess nom de domaine
SQL
1 vote269 views2 answers
Mysql error 1215
SQL
3 votes282 views1 answer
Oracle APEX elapsed time
SQL
15 votes284 views2 answers
Select where duplicate mysql
SQL
0 vote293 views1 answer
Create table split string function in sql server
SQL
0 vote277 views1 answer
Mysql multiple count
SQL