Hi all,
I have a database containing a following data:
Table Mieszalnia:
CREATE TABLE [Mieszalnia11]
(
[IdWpis] integer NOT NULL PRIMARY KEY AUTOINCREMENT ,
[IdMat] integer,
[Data] integer,
[Partia] varchar (10),
[Kontener] varchar (10),
[Uklad] varchar (5),
[Opis] varchar (256)
);
with data:
IdW IdMat Partia Kont Uk Data
12 1 1179760 136832 F16 1171951258
14 2 1176865 315060 F21 1171915832
14 3 1177504 318272 F9 1171538132
15 4 1153571 277827 F15 1171437632
16 5 1153437 062022 F13 1171368032
17 6 1185543 323063 SL1 1171978232
18 7 1156166 077690 F3 1169082032
19 8 1156269 075825 F8 1168888832
20 9 1166581 101109 F11 1168014032
21 10 1099211 081868 F17 1166497232
22 11 1084774 054445 F20 1169530232
23 12 1143641 157155 F24 1171485032
24 13 1180275 179329 SF3 1169521232
25 14 1102698 150010 SF4 1171494000
26 15 1130267 266647 SF5 1170282600
27 6 111111 111111 sl1 1172135769
28 6 33333 33333 sl1 1172054927
Now, when I run a query:
SELECT Mieszalnia.IdMat, Mieszalnia.Partia, Mieszalnia.Kont,
Mieszalnia.Uk, Max(Mieszalnia.Data) FROM Mieszalnia;
I always get:
IdMat Partia Kont Uk Data
6 33333 33333 sl1 1172135769
In this result there is indeed max from Data field but rest of the fields
fit not...I think result should look like:
IdMat Partia Kont Uk Data
6 111111 111111 sl1 1172135769
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
