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