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