Hi all,

I read about Interbase's ability to attach to multiple databases within a
single transaction context, using two-phase commits etc. I can see that
TIB_Transaction has properties IB_Connection1, IB_Connection2 and I assume
they are there for this purpose.
My question follows: Can I join tables from multiple databases?
TIB_Statement has only one IB_Connection property. Is there a syntax for
qualifying table names with database names in a SELECT ... JOIN statement?
The Embedded SQL Guide shows such syntax by prefixing tablenames with
database handles previously declared with a SET DATABASE. Is something like
this also possible in TIB_Query or another IBO data access component?

I guess I could use a datasource to create a master-detail link but I
presume that a join performed on the server (I'm thinking about two
databases on a single server) would be much more effective.

Thanks in advance for your ideas.
TOndrej