I havent worked with multiple databases before, but I would think you could just union two queries together if nothing else.
Eg: select ... union select ... order by col Bob Envision Information Technologies Associate [EMAIL PROTECTED] v. 608.256.5680 f. 608.279.3780 -----Original Message----- From: Michael Ruck [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 09, 2005 12:49 PM To: [email protected] Subject: [sqlite] How to unite query results from two databases I need to perform a select, which queries two databases (same tables and columns in both databases; both open at the same time in the same SQLite session via ATTACH DATABASE.) I need the query result to appear as a single result with sorting etc. performed on the entire result from both databases. Does someone have an idea of how to perform this in SQLite? Thanks, Michael
