|
|
o intrebare...
-
 07-30-2007, 4:53 PM |
|
-
ioana
-
-
-
Joined on 07-30-2007
-
Targu Mures
-
db_datawriter
-
-
|
Urmatorul UPDATE e facut pt Access DB si vreau sa-l transform pt SqlServer si nu stiu cum sa transform ce e in paranteza dupa UPDATE....
are cineva vreo idee???
UPDATE (ArtKrit INNER JOIN _b_QryPflichtWerte_NotK ON ([_b_QryPflichtWerte_NotK].KritNr = ArtKrit.KritNr)
AND (ArtKrit.GenNr = [_b_QryPflichtWerte_NotK].GenNr) AND (ArtKrit.ArtNr = [_b_QryPflichtWerte_NotK].ArtNr))
INNER JOIN ArtPflicht
ON (ArtKrit.KritNr = ArtPflicht.KritNr)
AND (ArtKrit.GenNr = ArtPflicht.GenNr)
AND (ArtKrit.ArtNr = ArtPflicht.ArtNr)
SET ArtPflicht.Used = -1
MULTUMESC ANTICIPAT...
|
|
View Complete Thread
|
|
|