Devart Forums

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

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

I'm using Firebird 2.5 Release 2

It's possible??

Thanks,

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