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

2 votes95 views1 answer
How to delete view in sql
SQL
1 vote112 views1 answer
How to select multiple columns from different tables in mysql
SQL
0 vote98 views1 answer
Test sql query
SQL
0 vote108 views1 answer
Sql column contains special character
SQL
23 votes108 views4 answers
Sql server substring
SQL
2 votes115 views1 answer
Sql string_agg
SQL
0 vote111 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
1 vote99 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
13 votes98 views6 answers
Restart postgresql
SQL
0 vote92 views5 answers
Sql table intermédiaire
SQL