martin_carmichael2005 wrote:

>
>hello,
>we are using firebird 1.03.
>
>Is it possible to do cross database (multi-dababase) connection and
>query?
>
>Can someone explain how to connect and do a multiple database query?
>I need to select information from one database to insert into another.
>
>example:
>
>SELECT EMPNO FROM Database1:TABLE_EMP, Database2:TABLE_EMPNAMES
>WHERE ...
>
>thank you,
>
>
>

Martin,

In the current FB version you cannot do this.

You will need to make two connnectiosn from the client and merge (join)
the result at the client.

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 18/03/2005