On 2 Mar 2011, at 8:53am, alexis bialot wrote: > i do not believe it should be possible that a query with a left join > yields less results > than the exact same query with an inner join.
Do you have any null fields anywhere in either TABLE ? Nulls make analysis of what's happening very difficult because semantically they mean something like "don't know". This not only makes the rows returned from a JOIN tricky, but also influences functions like max() which I see you used. Apart from that, a LEFT OUTER should always return at least every record in the main TABLE. If it doesn't, there's something wrong. It might return additional rows too. Sorry, but your example is too complicated to tell me whether it's working right for you. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
