Igor Tandetnik <itandet...@...> writes: [..] > > See how you like this one: > > select * > from (select distinct year from Test) as AllYears > join (select distinct name from Test) as AllNames > left join Test t on (t.year=AllYears.Year and t.name=AllNames.name) > left join Test2 t2 on (t.TestId = t2.TestId); >
Hey Igor, that was my victim ;-); but nevertheless - you're the greatest and your solution seems very "clean" (only looking not analyzing) compared to my Oliver _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users