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 vote116 views1 answer
ORA-01950
SQL
57 votes281 views6 answers
Sql alter table
SQL
0 vote125 views1 answer
Set mysql socket file docker windows
SQL
1 vote132 views1 answer
T-sql disable system versioning
SQL
6 votes125 views5 answers
Sql add months to date
SQL
1 vote121 views1 answer
Sqlite create index
SQL
17 votes122 views4 answers
Postgres list users
SQL
0 vote123 views1 answer
Postgress append string in select
SQL
5 votes108 views1 answer
Mysql select greater than yesterday
SQL
0 vote109 views1 answer
How many rows affected in sqllite
SQL