> > 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 generating the query plan. > >For outer joins (of which SQLite only supports LEFT JOIN), the >distinction is significant.
That was my impression and consistent with my real-world findings (wall clock made). Just wanted to avoid a possible pitfall. Outer is another beast. Thanks Igor. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users