Hallo Lars,
hier noch einen drauf, der sämtliche Zwischenschritte überflüssig macht:
CREATE TABLE "max1" ("ItemID" SMALLINT, "Stufe" SMALLINT, "Max" SMALLINT,
PRIMARY KEY ("ItemID","Stufe"));
INSERT INTO "max1" SELECT "Items"."ItemID", "Einsätze"."Stufe", MAX(
"Erforderliche_Ausrüstung"."Anzahl" ) "Max" FROM
"Erforderliche_Ausrüstung", "Items", "Einsätze" WHERE (
"Erforderliche_Ausrüstung"."ItemID" = "Items"."ItemID" AND
"Erforderliche_Ausrüstung"."EinsatzID" = "Einsätze"."EinsatzID" )
GROUP BY "Items"."ItemID", "Einsätze"."Stufe";
UPDATE "max1" SET "Max"= (SELECT MAX("Max") FROM "max1" WHERE ("Stufe" < 3
AND "ItemID" = 1)) WHERE ("Stufe" = '2' AND "ItemID" = '1');
UPDATE "max1" SET "Max"= (SELECT MAX("Max") FROM "max1" WHERE ("Stufe" < 3
AND "ItemID" = 2)) WHERE ("Stufe" = '2' AND "ItemID" = '2');
UPDATE "max1" SET "Max"= (SELECT MAX("Max") FROM "max1" WHERE ("Stufe" < 4
AND "ItemID" = 1)) WHERE ("Stufe" = '3' AND "ItemID" = '1');
UPDATE "max1" SET "Max"= (SELECT MAX("Max") FROM "max1" WHERE ("Stufe" < 4
AND "ItemID" = 2)) WHERE ("Stufe" = '3' AND "ItemID" = '2');
Wobei ich den Start mit Deiner Select-Anweisung jetzt nicht weiter überprüft
habe.
Gruß
Robert
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
