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 vote47 views1 answer
How to import sqlite driver class in java using maven
SQL
2 votes45 views6 answers
Mysql change timezone
SQL
1 vote57 views1 answer
T-sql disable system versioning
SQL
0 vote44 views1 answer
Delete ids between sql
SQL
3 votes54 views1 answer
Oracle apex warn on unsaved changes
SQL
0 vote48 views1 answer
Contact mysql column field
SQL
4 votes49 views2 answers
Sqlalchemy_database_uri for mysql
SQL
8 votes44 views4 answers
Convert date to dd/mm/yyyy sql
SQL
0 vote47 views1 answer
Change magento database url usimg musql
SQL
1 vote49 views1 answer
What is in condition in sql
SQL