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 vote104 views1 answer
Sql where max date
SQL
5 votes124 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
13 votes102 views4 answers
What is sql
SQL
0 vote102 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
0 vote115 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
3 votes109 views2 answers
Get current year sql
SQL
0 vote105 views1 answer
Sql get number of days between two dates
SQL
0 vote111 views1 answer
Sql auto_increment syntax
SQL
0 vote106 views1 answer
Java mysql swing example
SQL
0 vote143 views1 answer
Mysql grant access to one database
SQL