CREATE TEMPORARY TABLE XYZ AS SELECT ... Is that what you're looking for?
> -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Joe Bennett > Sent: Friday, March 02, 2012 10:44 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Create Temp Table from Query > > Hi, > > I am looking for some info on how to take an sqlite query result and > move that into a temp table. My hope is to focus the subsequent queries > down to a smaller dataset... I've been searching Google a bit but have > not been able to find what I am loking for... I'm not sure if that > means this is not the optimum way to acheve what I'm looking for...?? > > > > > -Joe > _______________________________________________ > 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