>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
You cannot run a single SQL Query against two databases that reside on seperate remote machines via ODBC. You will either have to access them as native tables or if you must use ODBC then you will have to perform seperate SQL queries against each table and return whatever subset of data is possible into cursors. Then run your sql against the two cursors.
Michael McLain