[sqlite] Why it does not work properly?

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] va

[sqlite] Why it does not work properly?-now written correctly...

Hi all, sorry previous mail was not really readable... 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),

Re: [sqlite] Re: Why it does not work properly?

SF3 1169521232 25 14 1102698 150010 SF4 1171494000 26 15 1130267 266647 SF5 1170282600 27 6 11 11 sl1 1172135769 28 6 3 3 sl1 1172054927 woj <[EMAIL PROTECTED]> wrote: Now, when I run a qu

Re: [sqlite] What query should I use?

Hi Igor, Thanks for your reply, the query you have suggested works fine, but there is missing the first row, so the result look: IdText1 Text2 Text3 Text4 --- 31003 12 test04 test12 61005 11 test17 test67 71005