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 vote121 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
2 votes117 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
7 votes127 views1 answer
Oracle pagination query offset
SQL
0 vote125 views1 answer
Postgres clear table
SQL
16 votes120 views2 answers
Oracle ddl
SQL
1 vote113 views2 answers
Pl sql case
SQL
0 vote126 views1 answer
Oracle procedure teamplate
SQL
0 vote133 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote122 views1 answer
Sql server concat null
SQL
1 vote113 views1 answer
Oracle repeat_interval 5 minutes
SQL