Newbie question I have two tables and I want to copy (occasionally) a few thousand columns that have been added to table1 into table2, both tables have the same unique key but otherwise the columns are different.
table2 will be initially populated from table1 using INSERT into table table2 SELECT refno from table1 WHERE flag > 0 I could drop table2 and then do the above but will then obviously lose any data that has been modified in table2. How can I just append the new rows from table1 into table2 Thanks _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
