On 12-1-2017 21:44, startx252000@... [firebird-support] wrote:

> What is the way to make a join from 2 tables in two respective database
> (in same server) ?
>
> ex :
>
> Db1
> TableA
>
>
> Db2
> TableB
>
>
> how can i make somethink like this :
>
> SELECT tA.MATRICRS, tB.name, tB.age
> FROM TableA tA
> JOIN TABLEB tB ON ( tA.ID = tB.ID)

Plain and simple: you can't. At least not without transferring the data
from one database to the other database, or doing complex stored
procedure magic (ie: manual joining) with execute statement on external.

Mark
--
Mark Rotteveel