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:
>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).

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
ib-support? http://www.yahoogroups.com/community/ib-support

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


regards,
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
www.ibobjects.com