How would you create a select statement that merges two open sqlite databases?
select x from tablea.c1, y from tableb.c2
Open the first database and then use AddDatabase (used to be Attach) to add the second database to the database object. Now you can query both at the same time using Joins.
3 Likes