Hi folks, I would like to query a table and put the result in a new table, as in
INSERT INTO <newtable> SELECT * FROM <oldtable>;However, this only works if <newtable> already exists, which is actually quite cumbersome..
Is there a way to make the new table 'on the fly"? Regards, Bertwim _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users