Subject Re: [firebird-support] multi-database query
Author fabricioa@infolink.com.br
Besides the growing interest in such a feature, there's no support
of cross-db queries.
You can do distributed transactions, doing queries on each db but
you cannot do the type of query you want on FB...

> 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,
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>