Folks, this is called a "Teachable Moment", by James K. Lowden. ;-)
From: James K. Lowden Sent: Friday, April 5, 2019 12:31 PM To: [email protected] Subject: Re: [sqlite] Returning NULL or empty values when the SELECT does not satisfy all of the query On Fri, 5 Apr 2019 14:01:20 +0000 Jose Isaias Cabrera <[email protected]> wrote: > The owners of the business said that "there will never be...", The perfect opportunity for a CHECK constraint or to enforce a foreign key. --jkl _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
