Ah, this one's easier to follow. What do you mean by "in this case"? What was the condition that made it possible to remove the rest?
Again, thanks! > To: sqlite-users@sqlite.org > From: oliver....@web.de > Date: Sat, 25 Sep 2010 00:05:11 +0000 > Subject: Re: [sqlite] Need help with self-join (I think) > > sry, > > a little mistake - here's the correction: > > SELECT DISTINCT t.Year, b.Name, > (SELECT SomeValue FROM Test INNER JOIN Test2 WHERE Year = t.Year AND Name = > b.Name) AS SomeValue > FROM Test t > CROSS JOIN (SELECT DISTINCT Name FROM Test) b > ; > > > (results don't differ - in this case!) > > 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