On 11/17/16, Paul <de...@ukr.net> wrote: > That's why there was a LEFT JOIN in the first place, but as it seems, it > wasn't that good idea.
Try using CROSS JOIN instead of just JOIN or LEFT JOIN. The query planner in SQLite will not reorder a CROSS JOIN. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users