Re: [sqlite] ON conditions vs. WHERE conditions

> > What is the rationale about placing complex conditions in the ON part > > of an inner join rather than in an WHERE clause? > >Except for outer joins, the difference is purely stylistic. They are >functionally equivalent. In fact, SQLite internally rewrites the >former to the latter, before

Re: [sqlite] ON conditions vs. WHERE conditions

On Tue, Jul 20, 2010 at 9:43 AM, Jean-Christophe Deschamps wrote: > What is the rationale about placing complex conditions in the ON part > of an inner join rather than in an WHERE clause? My sense is that it is not so much about "complexity" but more about the logic of the

Re: [sqlite] ON conditions vs. WHERE conditions

Jean-Christophe Deschamps wrote: > What is the rationale about placing complex conditions in the ON part > of an inner join rather than in an WHERE clause? Except for outer joins, the difference is purely stylistic. They are functionally equivalent. In fact, SQLite internally