I'm trying to query two dbf tables one that is there at my database with a program on foxpro 2.6 and the other is one that i created apart on excel, if i do something like this:
1 jerry programmer
2 Mary analyst
i must be able to do this.
Select * from table1, table2 where table1.field1 = table2.field1
and get as result something like that
1 jerry programmer 1 project1
2 Mary analyst 2 project2
My problem seems to be that i created a file from a excel and save it as dbf file but when i try to do a query as simple as the one shown, it throws the messege error i configure it to throw.
By the way i'm using a Delphi interface i develope to query those tables and don't know the structure of the dbf files on foxpro. Basically i use the my app to query and get info that i need to know that the fox pro program does not give me.
How can i solve this? Any suggestions will be appreciated.