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

2007-05-16 Thread Martin Jenkins
B V, Phanisekhar wrote: Kennedy, You are using Join that's going to take time. I need the most efficient query. Dan's one of the SQLite developers, so presumably has a rough idea of what his suggested query will be doing... ;) Martin --

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

2007-05-16 Thread B V, Phanisekhar
is that true? > > > Chris, > I don't have any specific precise display sequence to mention it using > another column. > > > Regards, > Phanisekhar > > > > > -Original Message- > From: Igor Tandetnik [mailto:[EMAIL PROTECTED] > Sen

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

2007-05-16 Thread Dan Kennedy
hat true? > > > Chris, > I don't have any specific precise display sequence to mention it using > another column. > > > Regards, > Phanisekhar > > > > > -Original Message- > From: Igor Tandetnik [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 15,

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

2007-05-15 Thread B V, Phanisekhar
etnik [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 15, 2007 8:13 PM To: SQLite Subject: [sqlite] Re: Re: Order of result of a query? B V, Phanisekhar <[EMAIL PROTECTED]> wrote: > Assume the values in the OR clause, be replaced by some subquery. Then > in such scenarios how will I be abl

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

2007-05-15 Thread Igor Tandetnik
B V, Phanisekhar <[EMAIL PROTECTED]> wrote: Assume the values in the OR clause, be replaced by some subquery. Then in such scenarios how will I be able to maintain the order? I want the order of the subquery to be preserved in the main query. Show an example. I'd like to look at the ORDER BY cl