I am working on a program that is currently using SQLite. One of its features is the ability to attach to a second DB file. This is am important concept in my application because I have one DB for the general system and another for a specific 'document'.

The system does NOT do any multi-database or cross-database queries, the system just does a SELECT ... FROM system.<table> or a SELECT ... FROM doc.<table>.

Is there some type of attach commend or something that can be used once you are already connected to a DB to allow this behavior?