SQL - Join one table in one destination to another table in another destination (DBF)
I am doing an SQL join between 2 DBASE tables one is located on the local
Drive and the other is located on the Network drive.
The following is the code which i have used
NetPath = "O:\BASE\"
sLocalpath = App.Path
Set MyDbf = OpenDatabase(sLocalpath, False, False, "dBASE III;")
ssql1 = "SELECT " & sSqltable & ".* FROM DEALER INNER JOIN " & sSqltable & "
ON DEALER.DEAL_NUM = " & sSqltable & ".DEALERNO ORDER BY DEALER.DEAL_PCODE,
" & sSqltable & ".BARCODE;"
The problem i am having due to defining the Database directory as sLocalPath
the join to the DEALER.DBF is being carried out locally. But the file is
sitting in NetPath.
How can i JOIN the two Tables sitting in different locations.
Thanks
replyto
_______________________________
