Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (20.3k points)

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.

1 Answer

0 votes
by (40.7k points)

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".

Related questions

0 votes
1 answer
0 votes
1 answer
asked Dec 12, 2020 in SQL by Appu (6.1k points)
0 votes
1 answer
0 votes
1 answer
asked Oct 5, 2019 in SQL by Tech4ever (20.3k points)

31k questions

32.4k answers

500 comments

693 users

Browse Categories

...