I'm not sure how good an idea it is, but what I've done in the past is make a remmote view for each, then create a local view that has the two remote views in it, that way you can join them.
>how I can do a query in vfp for sql of two different base from information in two different connections
ICQ 10556 (ya), 254117