RE: [sqlite] Re: Order of result of a query?

2007-05-15 Thread Chris Peachment
(2, 8, 7, 3) is not fixed, which u have assumed in your reply. >Regards, >Phani >-Original Message- >From: Igor Tandetnik [mailto:[EMAIL PROTECTED] >Sent: Tuesday, May 15, 2007 5:27 PM >To: SQLite >Subject: [sqlite] Re: Order of result of a query? >B V, Phanisekha

RE: [sqlite] Re: Order of result of a query?

2007-05-15 Thread B V, Phanisekhar
I need the main query should to return (1, 6, 5, 2) not (1, 2, 5, 6). Here (2, 8, 7, 3) is not fixed, which u have assumed in your reply. Regards, Phani -Original Message- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 15, 2007 5:27 PM To: SQLite Subject: [sqlit

[sqlite] Re: Order of result of a query?

2007-05-15 Thread Igor Tandetnik
B V, Phanisekhar <[EMAIL PROTECTED]> wrote: Assume the database given below mainTable (rowid INTEGER, puid INTEGER) Assume main table be Rowid Puid 1 2 2 3 3 4 4 6 5 7 6 8