Keith...as a neophyte, I am totally blown away by your skill level in SQL and the ease with which you explain its underlying operations. I am extremly impressed by the 'flattening of the query' and its operation...it worked perfectly!!.
I am so happy that this forum has persons of your caliber who totally understands SQL and can provide efficient solutions to problems forum members, like myself, may have. Again, thanks and be well. > Subject: RE: [sqlite] What am I doing wrong? > Date: Fri, 8 Aug 2014 17:40:28 -0600 > From: kmedc...@dessus.com > To: eem...@hotmail.com > CC: sqlite-users@sqlite.org > > > Leaving out the extra fields the movie table, enforcing referential > integrity, and using "same column names" to hold the same data, and declaring > the right indexes, you can get a much more efficient solution, both in the > expression and the execution: > > These optimizations are only necessary *after* you have solved the problem, > and then really only if performance is inadequate. Enforcement of > referential integrity and ensuring good indexes should always be done, of > course. _____________________________ > >> 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