Subject RE: [firebird-support] Multiple Database Connection
Author Alan McDonald
> I may be wrong, but I think you can use IBExpert and IBEBlock to
> do this...
> -steve

you are correct but it's not SQL - it's IBEBlock magic

> Svein Erling Tysvaer wrote:
> > Firebird may use a transaction that spans several databases, but it is
> > impossible to refer to several databases in the same query.
> >
> > I can easily see that it could sometimes be handy to use selects like
> > you describe, but it is not difficult to see how complex it would be to
> > create a plan for how to retrieve the records. In theory, you
> might even
> > have one server using SuperServer, one classic and yet another the
> > embedded engine. One would have to tranfer one result set from one
> > database to the other and then link and continue the processing, and
> > that sounds extremely complex.
> >
> > Hence, I'm happy with the current behaviour when I do this
> myself - i.e.
> > write a program to first query one database, then lookup the other
> > database for each returned record and depending on the answer, decide
> > whether I want it in the final result set.
> >
> > Replication, as Alan wrote, is another good solution.
> >