On Tue, Mar 06, 2012 at 11:00:25AM -0600, Joe Bennett scratched on the wall: > 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?
No, that's the actual syntax: http://sqlite.org/lang_createtable.html You can also create the table manually and then INSERT into the table from a SELECT: INSERT INTO XYZ SELECT... http://sqlite.org/lang_insert.html -j > 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? -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
