select statement not working with joined dbf files

[charlotte49er]

I want to grab all of the fields from two dbf files. However, the following statement hangs up:

strSQL = "SELECT * FROM usgs_gages.dbf INNER JOIN usgsdata.dbf ON usgs_gages.SITE_ID=usgsdata.SITE_ID"

If I replace the * with the individual field names it works but I was hoping to not have to do that. Can anyone shed some light? Thanks in advance.

 

[mwolf00]

SELECT usgs_gages.* FROM usgs_gages.dbf INNER JOIN usgsdata.dbf ON usgs_gages.SITE_ID=usgsdata.SITE_ID


Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)