Trying to read a data base 4 file and getting an error

Question

I'm trying to read 5 DBF files, MINFODIV.DBF, MINFO.DBF, MODE.DBF, DIVISION.DBF, MENU.DBF using SQL statements. No problems reading each individually into a table using VB.Net. I created the following SQL statement using Flyspeed SQL Query on the files and it works.

In VB.net I get

"Syntax error (missing operator) in query expression
'midb1.AMOUNT
From MINFODIV.DBF midb1
Inner Join MINFO.DBF midb On midb1.MINFOID = midb.MINFOID
Inner Join MODE.DBF modb On midb.MODEID = modb.MODEID
Inner Join MENU.DBF medb On modb.MENUID = medb.MENUID
Inner Join DIVISION.DBF didb On didb.DIVISIONID = midb1.DIVISIONID'"

My select statement is as follows:

Select 
  modb.DESC, 
  medb.DESC As DESC1, 
  didb.DESC As DESC2, 
  midb1.AMOUNT 
From 
  MINFODIV.DBF midb1 
  Inner Join MINFO.DBF midb On midb1.MINFOID = midb.MINFOID 
  Inner Join MODE.DBF modb On midb.MODEID = modb.MODEID 
  Inner Join MENU.DBF medb On modb.MENUID = medb.MENUID 
  Inner Join DIVISION.DBF didb On didb.DIVISIONID = midb1.DIVISIONID