Re: [sqlite] General SQL question...

2009-04-02 Thread John Elrick
Igor Tandetnik wrote: > John Elrick wrote: > >> The following two queries appear to be functionally equivalent...that >> is to say the results they produce are identical. Is there any >> intrinsic advantage to one over the other? If so, what is that >> advantage? >> > > The difference is

Re: [sqlite] General SQL question...

2009-04-01 Thread Igor Tandetnik
John Elrick wrote: > The following two queries appear to be functionally equivalent...that > is to say the results they produce are identical. Is there any > intrinsic advantage to one over the other? If so, what is that > advantage? The difference is purely stylistical. According to http://sq

[sqlite] General SQL question...

2009-04-01 Thread John Elrick
While experimenting with several different ways of structuring the query referenced in "Improving Query Performance", I mentally raised a question I hope someone can answer. The following two queries appear to be functionally equivalent...that is to say the results they produce are identical.