Neat! Many thanks :)
Putting this logic together with my original query will be an interesting challenge, hehe. Do you believe this is the best solution? Chris > To: sqlite-users@sqlite.org > From: oliver....@web.de > Date: Fri, 24 Sep 2010 23:47:59 +0000 > Subject: Re: [sqlite] Need help with self-join (I think) > > Kristoffer Danielsson <kristoffer.daniels...@...> writes: > > SELECT DISTINCT t.Year, b.Name, > CASE > WHEN (SELECT TestID FROM Test WHERE Year = t.Year AND Name = b.Name) IS NULL > THEN NULL > ELSE (SELECT SomeValue FROM Test2) > END AS SomeValue > FROM Test t > CROSS JOIN (SELECT DISTINCT Name FROM Test) b > ; > > Oliver > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users