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

5 votes233 views2 answers
Mysql import gzip db
SQL
0 vote256 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
0 vote221 views1 answer
Oracle date summer time
SQL
0 vote223 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote262 views1 answer
Add user mysql wordpress
SQL
0 vote258 views1 answer
Sql constarint
SQL
0 vote227 views1 answer
Creation d'un trigger sql
SQL
0 vote341 views5 answers
Right join
SQL
8 votes225 views1 answer
Oracle search source code
SQL
0 vote249 views1 answer
SQL joins in python
SQL