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


[Non-text portions of this message have been removed]