SQL Server-INNER join podczas aktualizacji [duplikat]

Question

SQL Server-INNER join podczas aktualizacji [duplikat]

to pytanie ma już odpowiedzi tutaj : zaktualizować tabelę za pomocą JOIN w SQL Server? (11 odpowiedzi) Zamknięty 7 lat temu .

Mam poniższe zapytanie, które nie działa. Co robię źle? Czy to w ogóle możliwe?

UPDATE ProductReviews AS R 
   INNER JOIN products AS P 
       ON R.pid = P.id 
SET R.status = '0' 
WHERE R.id = '17190' 
  AND P.shopkeeper = '89137'

372

inner-join sql-server

Author: marc_s, 2012-03-06

Source

2 answers

To powinno wystarczyć:

UPDATE ProductReviews
SET    ProductReviews.status = '0'
FROM   ProductReviews
       INNER JOIN products
         ON ProductReviews.pid = products.id
WHERE  ProductReviews.id = '17190'
       AND products.shopkeeper = '89137'

57

Author: Bridge,
Warning: date(): Invalid date.timezone value 'Europe/Kyiv', we selected the timezone 'UTC' for now. in /var/www/agent_stack/data/www/doraprojects.net/template/agent.layouts/content.php on line 54
2012-03-08 14:43:37

score 796 · Accepted Answer

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';

796

Author: Aaron Bertrand,
Warning: date(): Invalid date.timezone value 'Europe/Kyiv', we selected the timezone 'UTC' for now. in /var/www/agent_stack/data/www/doraprojects.net/template/agent.layouts/content.php on line 54
2012-03-06 17:49:37