Also related to this you can if you use Borland BDE have two aliases and use that in a query.
Need to read up you can do that again. Then BDE uses Paradox to try and do it for you. But I also did
this long ago, but I do remember that it was slower than the access one.

In short. Programmatically you will need to solve this.

Hope it helps

Johannes

At 02:55 PM 03/07/2006, you wrote:

>What I can suggest , maybe not the best.
>
>Is we used Microsoft Acccess. Made ODBC connections to the db's and used that in the queries to combine.
>
>Then access will do the combination etc. But I did this long ago. certain there are oaks with more experience than can give
>tips on this.
>
>Hope it helps
>
>Johannes
>
>At 12:55 PM 03/07/2006, you wrote:
>
>>It's not solution and basic..:(
>>
>>like that, db1 one in paris, db2 in bonn, db3 in london, db4 in tokyo etc..
>>
>>Niko
>>
>>----- Original Message -----
>>From: "Alan McDonald" <alan@...>
>>To: <firebird-support@yahoogroups.com>
>>Sent: Monday, July 03, 2006 1:40 PM
>>Subject: RE: [firebird-support] Multiple Database Connection
>>
>>
>>>> Hi,
>>>> Configuration:
>>>>
>>>> - i have a four firebird database in my local/server computer.
>>>> - In my Delphi program ,i used zeos component /other not important.
>>>> - One database component and connected to only one database (such as db1)
>>>> - In db1 database has some procedures,triggers & views
>>>>
>>>> * My question:
>>>> - How can i connect to other databases (db2,db3, etc ) in Only SQL Query
>>>> ?
>>>> SELECT ........... FROM db1.table1, db2.table1 etc...????
>>>>
>>>> - How can call procedure,views and other dababase ddl functions
>>>> SELECT ..........FROM db1.procedure1, db4.procedure1 ??????
>>>>
>>>> thanks.
>>>
>>> you can't - put all the contents of the 4 dbs into one database. That's
>>> the
>>> best way to handle it.
>>> Alan
>>>
>>>
>>>
>>>
>>>
>>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>>
>>> 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
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> __________ NOD32 1.1627 (20060627) Information __________
>>>
>>> This message was checked by NOD32 antivirus system.
>>> http://www.nod32.com
>>>
>>>
>>
>>
>>
>>
>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>>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
>>
>>
>>
>>
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>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
>
>
>
>