I have foxpro 2.6 databases on more locations.

I can not changes the locations

I what to make an ODBC connection to tables on both location.

Now i have 2 connection.

I have to make a query over 2 databases from both locations

lsql = 'select * from tableloc1,tableloc2 where tableloc1.zipcode=tableloc2.zipcode'


=sqlexec(connection1,lsql,"temp") &&Not connection2
I can only use connection this does not wotk

Can someone help me

Kinde regards



Jan Dorresteijn