Yes, that is what I'm looking for. This type of query crashes my browsers so I'm assuming that the question is based on the concept and not the actual syntax? On Mar 2, 2012 10:08 AM, "Marc L. Allen" <mlal...@outsitenetworks.com> wrote:
> 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
