Subject Re: [IBO] Query using to different databases (GDB)
Author Helen Borrie (TeamIBO)
At 11:35 AM 12-03-02 +0000, Arpe wrote:
>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:
>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

No, IB does not support cross-database joins. There is no mechanism for
protecting the integrity of keys from one database to another....This, btw,
is off-topic for the IBO list. Do you know about

What you can do is query multiple databases inside one single transaction
and pass parameters from query to query. IBO supports this very well.

Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at