Thenk you Gerry. After some studying I now understand that the inner SELECT is executed for each outer row -- so trimming the outer result set early seems like a very good optimization idea.
Doug > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Gerry Snyder > Sent: Thursday, September 09, 2010 1:52 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Query suggestion? > > On 9/9/2010 11:32 AM, Doug wrote: > > Thank you Igor. > > > > You've helped me before with what also turned out to be a similar > > select referencing the same table twice. I guess it's a concept > > that I don't fully get. If there is a name for this technique > > I'll go Google and study up on it. > > > > You should be able to find some good info by googling :"correlated > subquery" > > > > Gerry > _______________________________________________ > 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
