Tristan Van Berkom wrote: > Are the JOIN statements equal to the logical AND statements,
Yes. > for all practical purposes ? If you drop all those superfluous LEFT OUTER and IS NOT NULL parts, the database will be able to optimize the first query (the one without subqueries) better. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users