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. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
