Jean-Christophe Deschamps <j...@q-e-d.org> 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 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. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users