--- In firebird-support@yahoogroups.com, "woodpack2020" wrote:

>
> Is there a way to join data from two database in one query/view?
>
> We have three companies using the same application, each running its
> own Firebird database. Is there a way to create one view which reads
> data from all the three databases?
>
> I'm not looking for the DataPump tools. I would like to do it in a
> Firebird-view.
>
> kind regards, Jan-Henk Reef

As others have told you, a database is the outer bound for any query.
What you could try to do, is to have a fourth database and replicate
from the three others to this fourth database. Then you would have a
database where you could run your query. Maybe this fourth database
also could act as a "disaster copy" in case any of the three other
databases crashed and there were no recent backup available, but I
know far too little about replication to say if that is possible.
Another option to consider, is to simply use one database and not
three separate ones.

Set