I didn't even think of the simplest solution... Thanks, Michael
-----Ursprüngliche Nachricht----- Von: Bob Dankert [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 9. Februar 2005 19:53 An: sqlite-users@sqlite.org Betreff: RE: [sqlite] How to unite query results from two databases 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: sqlite-users@sqlite.org 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