On 31 Jan 2019, at 5:46pm, Scott <scottvall...@yahoo.com> wrote: > I can return results successfully from the t.Topic and n.Deleted columns > separately, but when I try to use AND I receive no results.
There was an optimization bug that looked like your example in some previous version of SQLite. Are you running an up-to-date version of SQLite ? Are you doing this in your own code or in the SQLite CLI tool ? If possible, please test in the CLI tool. Please execute "PRAGMA schema.integrity_check" just in case your database is corrupt. Try removing everything that doesn't cause the problem. So remove the JOIN to the Source table. Swap the order of the conditions around the "AND". Swap the order of the JOIN clauses. Some combination of the above should tell you more about the problem. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
