On 31 Jan 2019, at 6:21pm, Scott <scottvall...@yahoo.com> wrote: > Figured it out! I had set the column Deleted to "CHAR" but all the fields > without 'X' were null. If I replaced null with a valid character it worked. > Thanks for your time.
Ah, JOINing on NULL. Well done. For future reference, SQLite doesn't have a CHAR type. For clarity you might want to use TEXT instead. SQLite does assume TEXT when you specify CHAR, but you might be depending on a specifically CHAR behaviour, like truncation to one character, and SQLite will ignore it. Well done for solving your problem. The magic of posting. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
