How do a join with 2 dbf files?

[ccb-it2013]

Hi there,

For the life of me I can't join 2 dbf files so that I can get the necessary data I need from the second database.

In my script I have this:

SELECT * FROM ADO CONMANPO_H

The name of the second dbf I need to get data from is called say CONMANPO_D . They field they have in common is called PONO.

I tried this:

LEFT JOIN CONMANPO_H on  PONO as CONMANPO_D

However I get a script error when I try running the script.

What am I doing wrong?? I am sure it is something really simple.

Thanks for your help!

[vishsaggi]

I am sorry, my mistake use i meant OLEDB not ODBC.

OLEDB CONNECT32 TO [Provider=VFPOLEDB.1;Data Source=G:\AIMS\QVDATA\CMP4\;Collating Sequence=general;];

Table1:

SELECT * FROM ADOCONMANPO_H;

OLEDB CONNECT32 TO [Provider=VFPOLEDB.1;Data Source=G:\AIMS\QVDATA\CMP4\;Collating Sequence=general;];

Table2:

SELECT * FROM ADOPOLINS;

[ccb-it2013]

I think you must use the VFPOLEDB driver or else the tables can not be read.

I apologize for the frustration and I appreciate your efforts to help me, I don't have anywhere else to turn to...

[vishsaggi]

What is VFPOLEDB?

[ccb-it2013]

This is the script I have:

S

So it would seem using the OLEDB driver works!

[ccb-it2013]

VisualFoxPro OLEDB driver

[vishsaggi]

Ok you have that driver?

[ccb-it2013]

Yes, this is what I have been using since we started using QV.

[vishsaggi]

Hi Edward,  you still facing issues with this? What time zone you are in?

[ccb-it2013]

Hi Vishwarath,

Yes, I am still having issues with joining the 2 tables to get the information needed for my report.

I am in the Eastern Daylight Savings Time zone.

Regards,

Edward

[vishsaggi]

We can screenshare if that is ok with you. Email me on vishsaggi@gmail.com