yes, ATTACH and then join using a SELECT statement. After you do the ATTACH, this video shows how to do the join using the SQLite command line interface. Notice how you can keep track of identically named fields in the two tables. https://www.youtube.com/watch?v=NcrZoHselPk
Jim On Tue, Jul 21, 2015 at 9:09 PM, Igor Tandetnik <igor at tandetnik.org> wrote: > On 7/21/2015 8:54 PM, Hayden Livingston wrote: > >> I would like to compare two tables (of the same name) in two separate >> database files. >> > > Are you looking for ATTACH DATABASE ( > http://www.sqlite.org/lang_attach.html ) ? > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
