problem with join

I am trying to do a join on two tables, with this SQL:

select M.CAPID, M.NameLast, M.NameFirst, M.NameMiddle,
M.NameSuffix, MA.CAPID, MA.Addr1, MA.Addr2, MA.City, MA.Zip
from Member M, MbrAddresses MA
LEFT JOIN MbrAddresses MA on M.CAPID=MA.CAPID

I am using a TADODataSet component, which appears to be unhappy with
the command. I tried using an online validator, and it complains at the
field name MA.State. Is there a problem using the name State?

I am trying to import data from a collection of MS Access tables
created elsewhere, and I did not (and cannot) choose the field names.

--

Bill
.