If I understand your question, yes, you can join tables from different database files, and you can do it directly.
http://www.sqlite.org/lang_attach.html E.g., ATTACH 'MyOtherDatabase.db' AS other Then, prefix tables in the second database with other. E.g., select other.addresses.postalcode -----Original Message----- From: Shilpa Sheoran [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 12:29 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Join Does sqlite allow joining tables in different database files using triggers or any other mechanism? Does it affect the performance? Thanks Shilpa ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ----- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
