howdy! Questions:
suppose tables t1 & t2 exits in two separate db files, d1 & d2 respectively. t1 & t2 have identical schemas, but different data. I want to append t2 to t1. I suppose the way to do that is to open a connect to d1, use the attach command to reference d2.t2 and issue a "INSERT INTO t1 SELECT * FROM d2.t2;" query. Is that correct? Is there a better way? Is this operation inefficient or pitfalls any pitfalls to watch out for? -James _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
