On May 30, 2012, at 2:21 AM, Charles Samuels wrote: > This query's result should be identical weather or not we have that join; > it's > an outer join, not an inner join, afterall.
The outer join could affect the cardinality of the result (i.e. there could be multiple rows matching the driving table). Therefore, no, it cannot be discarded without additional information regarding the nature of the reference (i.e. to-one). _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
