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 vote379 views3 answers
Constraint sql
SQL
0 vote376 views1 answer
Sql show founctions
SQL
0 vote343 views1 answer
Store case result sql
SQL
8 votes310 views1 answer
Alter tablespace add datafile
SQL
-1 vote318 views1 answer
Ssql to lowercqse
SQL
0 vote337 views1 answer
Update having mysql
SQL
0 vote323 views1 answer
EnvironmentError: mysql_config not found
SQL
11 votes325 views1 answer
Sql insert multiple rows from select
SQL
9 votes306 views2 answers
Default number in sql
SQL
0 vote323 views1 answer
Table values functions in SQL
SQL