Hi there... Thanks for your reply!
> Works for me, I get two rows. Not the ones you expect though: nothing says > that the > engine must choose the first (or last, or any particular) row to represent > the group. After trying so many invalid constructions that was the only one that was giving me any good result, so I went for it... > Try this: [cut] I tried all of them... none working I'm afraid... Seems to me like it can't access external query fields from sub-query. Giving me always error - 'l1.lineID' is unknown column... I'll start tomorrow afresh... There must be a way... :/ -- Jo _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
