Igor Tandetnik wrote: > John Elrick <john.elr...@fenestra.com> 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://sqlite.org/optoverview.html, all conditions in ON clauses are > logically moved to WHERE clause before query plan is determined. >
Thank you, Igor. John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
