Helo, we are converting a multi-enterprise application from db7 to IB. The
application has common table has enterprise specific ones. In db7 could make
queries like this:
SELECT A.*,B.*
FROM 'c:\app\data\common\table1.dbf' A LEFT JOIN
'c:\app\data\enterprise001\table2.dbf' B on (A.ID = B.ID)

How could it be done in IB?
Note, using several GDBs is a must (needed to use data from other
applications).

Thanks, Dario