2 Databases

fvazquez · Post by **fvazquez** » Mon 29 Mar 2010 07:00

Hello,

Is possible to retrieve records from 2 separated databases in one select query statement with IBDAC?

Example:

SELECT TABLE_A.*, TABLE_B.*
FROM TABLE_A, TABLE_B
WHERE TABLE_A.FIELDA = TABLE_B.FIELDA

(note: TABLE_A in DATABASE_A and TABLE_B in DATABASE_B)

Regards,

Francisco

Dimon · Post by **Dimon** » Mon 29 Mar 2010 08:44

InterBase server doesn't allow to execute such SELECT query.

fvazquez · Post by **fvazquez** » Mon 29 Mar 2010 09:15

I'm using Firebird 2.5 Release 2

It's possible??

Thanks,

Dimon · Post by **Dimon** » Mon 29 Mar 2010 09:50

You can find information about it by the following link:
http://www.firebirdfaq.org/faq16/