SQLite - How do you join tables from different databases?

Question

I have an application that uses an SQLite database and everything works the way it should. I'm now in the process of adding new functionalities that require a second SQLite database, but I'm having a hard time figuring out how to join tables from the different databases.

If someone can help me out with this one, I'd really appreciate it!

Edit: See this question for an example case you can adapt to your language when you attach databases as mentioned in the accepted answer.

Answer 1

If the  ATTACH  function is activated in the build of Sqlite (it should be in most builds), then you can attach another database file to the current connection using the  ATTACH  keyword. 

The limit on the number of db's that can be attached is a compile-time setting (SQLITE_MAX_ATTACHED), currently defaults to 10, but this too may vary by the build you have. The global limit is 125.

attach 'database1.db' as db1;

attach 'database2.db' as db2;

You can use the below code to see all connected databases with keyword

.databases

Now, you will be able to do the following:

select

  *

from

  db1.SomeTable a

    inner join 

  db2.SomeTable b on b.SomeColumn = a.SomeColumn;

Note: Here, "[t]he database names main and temp are reserved for the primary database and database to hold temporary tables and other temporary data objects. Both of these database names exist for every database connection and should not be used for attachment".