Hi, see http://www.sqlite.org/lang_attach.html
you attach a second database, giving it a name, and prepend this name to the table name. Martin Zhenyu Guo schrieb: > Hi guys, > > I have multiple sqlite databases in hand, and I would like to perform the > following several tasks: > > . two tables with the same schema are in two dbs, and I want to apply a sql > query to the two tables efficiently (merge them into one table? Merge cost is > also considered as the total cost. Is there a way to logically combine these > two tables into one? Other mechanisms?) > > . two table with different schemas are in two dbs, and I want to apply a join > query to the two tables efficiently (if I can logically have them in one db, > that will be better.) > > Thanks, > Zhenyu > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
