>Actually the two backends are Visual Foxpro which makes it very difficult and the sql statement we are using is to create a Datareport.

Well, just for the heck of it I tried doing a Select clause using two databases (in VFP you just qualify the table with the db name to do a multi-db query) and it works!

Obviously I didn't know this would work with the VFP ODBC driver.. anywho, try a query like this:

or=oc.execute("select * from multi1 a join testdata!multi2 b on a.id=b.id")

Where the first table is contained in the dbc that the DSN/sourcedb specifies and the testdata is the other database. Both databases exist on the same directory, that probably makes a difference.

I hope this helps you, it sure helped me on finding about this.