Can anyone tell me how to do this properly? I have 2 dbase databases in the same directory. I want to use SQL to join them on a common field. The following code works fine if I use it on 2 tables in a microsoft access database, but won't work with dbase databases
dim db as Database
dim Rs as recordset
dim SQL as String
SQL = "Select * from one, two where one.id = two.id"
set db = openDatabase("C:\directory",true, true,"dbase IV")
Set rs = db.openRecordSet(SQL,dbOPenDynaSet)
'This code assumes one and two are two dbase databases stored in the same directory.
Anyone know how to do this?