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 vote144 views2 answers
Delete the last item in a table sql
SQL
0 vote169 views2 answers
Functions with parameters SQL
SQL
0 vote184 views1 answer
Alter table change default
SQL
1 vote171 views1 answer
Postgres convert exisiting column to text
SQL
25 votes197 views1 answer
How to update an attribute in MySQL
SQL
31 votes189 views3 answers
Sql count
SQL
0 vote190 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
1 vote167 views1 answer
Get url of cpanel database hostname
SQL
2 votes197 views2 answers
Storing timezones in postgres
SQL
9 votes177 views6 answers
Sql insert into
SQL