I am attempting to copy records from one table to another using the syntax : Select field1, field2 into {empty table just created} from {existing table with a bunch of records} I get an error "Error near "Into" The destination table has only field1 and field2 which are also in the source table.
This query is what I see everywhere when I google how to "Copy records from one table to another" What gives??? Thanks -- View this message in context: http://old.nabble.com/Select-Into-not-working-tp31420546p31420546.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users