JOIN sql statement works on Access but not dbf's - help

[charlotte49er]

I am trying to join together 3 separate dbf files (common field is SITE_ID) using the following sql statement in an asp page:

strSQL = "SELECT extents.*, usgsdata.*, usgsgage.* FROM usgsgage.dbf INNER JOIN (extents.dbf INNER JOIN usgsdata.dbf ON extents.SITE_ID = usgsdata.SITE_ID) ON usgsgage.SITE_ID = usgsdata.SITE_ID;"

I haven't had much luck so I imported these tables into an Access db, removed the file extensions, and ran the sql statement from the asp page and it worked! (on a side note, if I just run the join on two of the dbf files it works). Since these are dbf files and I need to update them I am using the Visual FoxPro driver. I am guessing that there is something peculiar in the driver. Can anyone help me out? Unfortunately, we have no other choice than to use these dbf files. Thanks.

 

[Cagliostro]

I think you should put your question on FoxPro forum.

Ion Filipski