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" <[email protected]> wrote:
> CREATE TEMPORARY TABLE XYZ AS > SELECT ... > > Is that what you're looking for? > > > -----Original Message----- > > From: [email protected] [mailto:sqlite-users- > > [email protected]] On Behalf Of Joe Bennett > > Sent: Friday, March 02, 2012 10:44 AM > > To: [email protected] > > 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 > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
