Others have answered that multidatabase queries are not possible with
Firebird at the moment. The one thing Firebird is capable of, is
multidatabase transactions (i.e. separate queries for each database,
but both queries within the same unit of work). Though I do not know
whether IBX supports this or not since I only use IBO.

Set

--- In firebird-support@yahoogroups.com, "Gustavo" wrote:
> Hello:
>
> Suppose I have two databases named Database1 and Database2. In
> Database1 there is a table named Table1 with fields Field11 and
> Field12 and in Database2 there is a table named Table2 with fields
> Field21 and Field22. The question is:
>
> Is it possible to make a multidatabase query like the following?
>
> SELECT Table1.*, Table2.Field22
> FROM Database1.Table1, Database2.Table2
> WHERE (Table1.Field11 = Table2.Field21)
>
> I'm using Delphi 5 and IBX. I use the TQuery component but in its
> property Database I can assign only one database.
>
> If it´s impossible to do this with Firebird... Does anybody have any
> idea of how can I obtain my query in another way?
>
> Thanks in advance.
>
> Gustavo