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