On Wed, 2009-08-12 at 07:02 -0700, Leo Freitag wrote:
>
> I modified the code a get the following results. Unfortunetly only a little
> more as expected:
>
> DROP TABLE 'tblZO_Haupt';
> CREATE TABLE 'tblZO_Haupt' ('id' INTEGER PRIMARY KEY, 'zo_tblEnsemble'
> INTEGER, 'zo_tblSaenger' INTEGER, 'zo_tblStueck' INTEGER, 'zo_tblStimmbez'
> INTEGER, 'datum' TEXT);
> INSERT INTO "tblZO_Haupt" VALUES(1,1,1,1,11,'2009-08-01 00:00:00');
> INSERT INTO "tblZO_Haupt" VALUES(2,1,2,1,11,'2009-08-01 00:00:00');
> INSERT INTO "tblZO_Haupt" VALUES(3,1,1,1,20,'2009-08-05 00:00:00');
> INSERT INTO "tblZO_Haupt" VALUES(4,1,2,1,20,'2009-08-05 00:00:00');
> INSERT INTO "tblZO_Haupt" VALUES(5,2,1,1,11,'2009-08-01 00:00:00');
> INSERT INTO "tblZO_Haupt" VALUES(6,2,1,1,20,'2009-08-05 00:00:00');
> INSERT INTO "tblZO_Haupt" VALUES(7,2,1,1,14,'2009-08-02 00:00:00');
> INSERT INTO "tblZO_Haupt" VALUES(8,2,2,1,14,'2009-08-02 00:00:00');
>
> SELECT * FROM tblZO_Haupt AS hpt
> WHERE hpt.datum = (
> SELECT MAX(hpt_sub.datum)
> FROM tblZO_Haupt AS hpt_sub
> WHERE hpt_sub.zo_tblSaenger = hpt.zo_tblSaenger
> AND hpt_sub.zo_tblEnsemble = 1
> AND hpt_sub.zo_tblStueck = 1
> AND hpt_sub.datum <= '2009-08-03 00:00:00')
AND hpt.zo_tblEnsemble = 1
AND hpt.zo_tblStueck = 1;
As written, you were selecting any record with the correct date
regardless of Ensemble or Steuck.
David
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
