Oops, I see that you wanted a join across DB's not a pump.

Look into using CalculatedFields and populate the values in one query from a
lookup in another.

Use the Lookup() method of the query to the other database.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Jason Wharton" <jwharton@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, January 30, 2001 4:54 PM
Subject: Re: [IBO] Query on two DBs - ?how do I do it?


> Two connections, one or two transactions, one cursor and a DSQL with an
> INSERT statement. A datapump with the source set to the cursor and the dst
> set to the DSQL. Line up the columns using DstLinks, prepare and pump the
> data calling Execute.
>
> That's it in a nutshell.
>
> If you want more inf. as more specific questions.
>
> HTH,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "Michael L. Horne" <guardian@...>
> To: <ibobjects@yahoogroups.com>
> Sent: Tuesday, January 30, 2001 1:26 PM
> Subject: [IBO] Query on two DBs - ?how do I do it?
>
>
> > Hello
> >
> > Using IBO, how do I setup a query that will combine
> > data from 2 different DBs?
> >
> > 1. Setup Components?
> > 2. Write the SQL?
> >
> > Thanks
> > Michael L. Horne
> >
> >
> >
> >
> >
>
>
>
>
>