A query cannot span several databases. What can be done - depending on
which tool you use - is to have a transaction span several databases.

The alternative would of course be to keep all data in the same
database, just in two different tables.

Set

--- In firebird-support@yahoogroups.com, "gerlia2002" <actnow_a@b...>
wrote:

> I store recent General Ledger Transactions in database 1,
> and older General Ledger Transactions in database 2.
>
> How can I select and sum the data from the 2 databases
> into one query?