On 12-1-2017 21:44, startx252...@yahoo.fr [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