> On Jan 26, 2018, at 1:36 PM, Richard Hipp <[email protected]> wrote: > > For now, please use CROSS JOIN instead of INNER JOIN to force the > correct join order.
You're right, that fixed the query. Thanks! I must admit, I don't understand the significance of join order here. It seems to me that the results would be the same whether "itemDS" or "categoryDS" is the outer loop; it's only performance that might change. Could someone explain? —Jens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
