Use UNION to run queries against each db and return a single result. HTH,
Sam ------------------------------------------- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -----Original Message----- From: Tom Deblauwe [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 04, 2007 5:28 AM To: sqlite-users@sqlite.org Subject: [sqlite] attached databases Hello, As I understand it, you can attach databases together with sqlite and then perform 1 query on all the databases together. I have this situation where I have 3 disks, and every disk contains a database, and each of those databases has the same structure: ID, TimeFrom, TimeTo, Events I would like to do a query on all 3 databases, where I check the bitmask of 'Events' for a certain value and sort the results in ascending order based on TimeFrom. Can I do this with SQlite? How does the query look like, and what columns are returned then? Hopefully the full list with only 4 columns, not 12(3 db's x 4 columns)? Thanks for your time, Best regards, Tom, ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
