SQLite – How do you join tables from different databases?

by

If ATTACH is activated in your build of Sqlite (it should be in most builds), 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 see all connected databases with keyword

.databases

Then you should be able to do the following.

select
  *
from
  db1.SomeTable a
    inner join 
  db2.SomeTable b on b.SomeColumn = a.SomeColumn;

Note that “[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”.

More Related Contents:

  1. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  2. What is the difference between Left, Right, Outer and Inner Joins? [duplicate]
  3. How can I list the tables in a SQLite database file that was opened with ATTACH?
  4. SQLite INSERT – ON DUPLICATE KEY UPDATE (UPSERT)
  5. What is the difference between JOIN and UNION?
  6. FULL OUTER JOIN with SQLite
  7. Deleting duplicate rows from sqlite database
  8. Does SQLite3 not support foreign key constraints?
  9. SQLite – ORDER BY RAND()
  10. How to get a list of column names on Sqlite3 database?
  11. Drop all tables command
  12. What is semi-join in database?
  13. Core Data Performance with Single Parent Entity
  14. Venn Diagram for Natural Join
  15. Android multiple databases open
  16. sqlite select with condition on date
  17. SQLite3 UNIQUE constraint failed error
  18. Copy table structure to new table in sqlite3
  19. How can I schedule a job to run a SQL query daily?
  20. Reset identity seed after deleting records in SQL Server
  21. SQLite Reset Primary Key Field
  22. MySQL dump by query
  23. How would you implement sequences in Microsoft SQL Server?
  24. SQL how to compare two tables for same data content?
  25. What does =* mean?
  26. Query to get records based on Radius in SQLite?
  27. Favourite performance tuning tricks [closed]
  28. How do I import .sql files into SQLite 3?
  29. Database efficiency – table per user vs. table of users
  30. Why do multiple-table joins produce duplicate rows?

Leave a Comment