To reiterate, Keith: to get the query to execute properly, I didn't change the LEFT JOIN to an INNER JOIN! Nope, I rewrote
SELECT FROM a LEFT JOIN b ON <key> WHERE b.c=5 to SELECT FROM a LEFT JOIN b ON <key> AND b.c=5 WHERE b.c IS NOT NULL So I just added a redundant predicate and it runs perfectly, on SQLite! That's why I said this simple improvement can surely be taken care of on the optimizer, while the larger discussion of actually changing the outer join to an inner join or even tackling the -OR- case is for sure something nice to think of, but increasingly more complicated. -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
