On 13 Dec 2016, at 3:20pm, Paul Egli <e...@sourcegear.com> wrote: > Why must SQLite find rows where the value is NULL?
Because the related fields in the offspring row might have NULL in them, and SQLite needs to know how to find the parent row for that row. Mind you, if the relating key field(s) are defined as NOT NULL, you have a good suggestion. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users