On Sun, 16 Nov 2008 18:28:50 +0900, "Alexandre Courbot" <[EMAIL PROTECTED]> wrote: >attach is probably what you want:
Thanks. For those interested, here's how to load two database files into the sqlite3.exe CLI, and retrieve rows that have a common "code" value in two tables: C:\> sqlite3.exe .attach db1.sqlite .attach db2.sqlite SELECT 'db1',db1.table1.mycol1,'db2',db2.table1.mycol1 FROM db1.table1,db2.table1 WHERE db1.table1.code=db2.table1.code; _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
