Ceva de genul:

 

UPDATE
ArtPflicht
SET Used = -1
FROM
ArtKrit A
JOIN _b_QryPflichtWerte_NotK B
 ON B.KritNr = A.KritNr
 AND A.GenNr = B.GenNr
 AND A.ArtNr = B.ArtNr
JOIN ArtPflicht C
 ON A.KritNr = C.KritNr
 AND A.GenNr = C.GenNr
 AND A.ArtNr = C.ArtNr

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro