No, that i can't do, already first database is big in size and the table2 is linked with another tables in the database2.
 
So, i want to try for sql statement.
 
Thanks for reply.
 
Regards.
 
Vishal

--- On Thu, 24/12/09, Dimitry Sibiryakov <sd@...> wrote:


From: Dimitry Sibiryakov <sd@...>
Subject: Re: [firebird-support] How to get data from two different databases
To: firebird-support@yahoogroups.com
Date: Thursday, 24 December, 2009, 8:09 PM


> I don't have any idea that how to get the data from two different databases using a single sql statement.

   But I guess you know how to get the data from one database. Copy data
from second database into first one, using FBCopy and that's all.

   SY, SD.


------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links






The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/

[Non-text portions of this message have been removed]