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

Reply via email to