Subject Re: [firebird-support] What the best way to to join 2 tables accross 2 databases ?
Author Alexandre Benson Smith
Em 19/3/2012 00:15, Helen Borrie escreveu:
> At 02:19 PM 19/03/2012, Alexandre Benson Smith wrote:
>
>> You can do cross database joins using execute statement in FB 2.5.
> It's true that you can perform DML in an external database from within a PSQL module in v.2.5, using the EXECUTE STATEMENT extensions. But, no, you can't do cross-database joins in Firebird at all. It won't happen until Firebird supports database namespaces, which is not yet.
>
> ./heLen
>
>

Helen,

Thanks for the clarification... I'm not using 2.5 yet, but I recall to
take a look on this feature (cross database DML), Perhaps I did an SP to
check on another database... I will look for the test I did.

To the OP: Sorry for the misinformation