Subject Re: [firebird-support] Query across 2 different gdb's
Author Helen Borrie
At 08:54 PM 13/01/2004 +0000, you wrote:
>I have 2 gdb's with exact same tables, and table structure. Is there
>any way to return a single recordset with a query to both?


Firebird doesn't support joins or other multi-table operations across
database boundaries. It does support concurrent queries across database
boundaries inside a single transaction, i.e. a client can read data from a
query on one db and pass them into parameters for a DML query on another.