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 vote359 views1 answer
Add constraint sql
SQL
2 votes370 views1 answer
How to delete view in sql
SQL
4 votes413 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
11 votes380 views2 answers
You are using safe update mode
SQL
5 votes354 views2 answers
Sql server check port number
SQL
0 vote401 views3 answers
Mysql keyword search
SQL
0 vote375 views1 answer
Sql output select
SQL
9 votes362 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote372 views1 answer
Psql datestyle
SQL
0 vote365 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL