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
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: Tues

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, 2007

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

2007-05-16 Thread B V, Phanisekhar
[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 able