>> I was under the impression that the order of fields in the ON clause doesn't >> matter. Is this impression incorrect? > > You should be correct, and the latest version of SQLite has some changes in > which look relevant to this issue. Can you check which version of SQLite > you're using and possibly download the latest version and see if this fixes > your issue ?
It doesn't - still present in 3.7.14.1. Thanks, Hamish _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users