--- In ib-support@y..., hectorhds@y... wrote:

> I've a question.
>
> How can I do a Join between two tables that are stored in two
> different database files in interbase. Also, how can I use
> the '[IN]' clausule to include a table that is stored in another
> dbfile. Can i do that?
>
> Tnks!, ah!,Im new in this list... Sorry if these questions are too
> simplex.

Hi Hector?

You can't do it via native IB connectivity components but can via
BDE, check Delphi documentation for heterogenious queries. It will be
monsterously slow, I suggest to think about combining your databases
into one.

Best regards.