access 求解决

select ID, SAMPLETYPE, CHECKUP from (SELECT A.*,TYPENAME AS TEMPERATURETYPENAME FROM(SELECT A.*,TYPENAME AS AGROTYPENAME FROM(SELECT A.*,TYPENAME AS LIGHTTYPENAME FROM(SELECT 
A.*,TYPENAME AS WATERTYPENAME FROM(SELECT A.*,TYPENAME AS LIFEFORMTYPENAME FROM(SELECT A.*,TYPENAME AS PLANTTYPENAME FROM(SELECT A.*,TYPENAME AS FREQUENCYTYPENAME FROM(SELECT
A.*,TYPENAME AS RESOURCETYPENAME FROM(SELECT A.*,B.TYPENAME AS SAMPLETYPENAME FROM(SELECT
A.ID,A.SAMPLETYPE,A.RESOURCETYPE,A.FREQUENCYTYPE,A.PLANTTYPE,A.LIFEFORMTYPE,A.PLANTHEIGHT,A.DIAMETER,A.WATERTYPE,A.LIGHTTYPE,A.AGROTYPE,A.TEMPERATURETYPE,A.SOURCELATIN,
A.GENUSNAME,A.COLLECTID,A.PLANTNUM,A.COLLECTPEOPLE,A.COLLECTDATE,A.COLLECTPLACE,A.LONGITUDE,A.LATITUDE,A.ALTITUDE,A.UTILIZATION,A.THREATENED,A.REMARK,A.CHECKUP,A.ROOT,
A.PICROOT,A.PICCAUDEX,A.FOLIAGE,A.PICFOLIAGE,A.BUD,A.PICBUD,A.BLOOM,A.PICBLOOM,A.FRUIT,A.PICFRUIT,A.SEED,A.PICSEED,A.FUNADDAPP,A.WORKINGPEOPLE,A.JOBOPERATION
,A.KEYPROGRAM,A.PLANTID,A.FIELDID,A.TRADITONALID,A.WEIGHT,A.SOURCEID,A.SUBJECTID,A.HERBALID,A.ALIASNAME,A.HERBALPART,A.HERBALNAME,A.SOURCETYPE,A.PLANTNAME,A.PLANTLATIN,B.TYPENAME AS SUBJECTNAME FROM(SELECT A.*,B.SOURCETYPE,B.PLANTNAME,B.PLANTLATIN FROM(SELECT A.*,B.HERBALNAME FROM(select t.ID,t.SAMPLETYPE,t.RESOURCETYPE,t.FREQUENCYTYPE,t.PLANTTYPE,a.LIFEFORMTYPE,t.PLANTHEIGHT,t.DIAMETER,t.WATERTYPE,t.LIGHTTYPE,t.AGROTYPE,t.TEMPERATURETYPE,t.SOURCELATIN,
t.GENUSNAME,t.COLLECTID,t.PLANTNUM,t.COLLECTPEOPLE,t.COLLECTDATE,t.COLLECTPLACE,t.LONGITUDE,t.LATITUDE,t.ALTITUDE,t.UTILIZATION,t.THREATENED,t.REMARK,t.CHECKUP,t.ROOT,
t.PICROOT,t.CAUDEX,t.PICCAUDEX,t.FOLIAGE,t.PICFOLIAGE,t.BUD,t.PICBUD,t.BLOOM,t.PICBLOOM,t.FRUIT,t.PICFRUIT,t.SEED,t.PICSEED,t.FUNADDAPP,t.WORKINGPEOPLE,t.JOBOPERATION,
t.KEYPROGRAM,t.PLANTID,t.WEIGHTID,t.FIELDID,t.TRADITONALID,t.WEIGHT,a.SOURCEID,a.SUBJECTID,a.HERBALID,a.ALIASNAME,a.HERBALPART from new_samplelist_110000 t left join
(SELECT A.ID,A.SOURCEID,A.SUBJECTID,B.HERBALID,B.ALIASNAME,B.HERBALPART,A.LIFEFORM as LIFEFORMTYPE FROM DATA_PLANTINFO_110000 A LEFT JOIN DATA_PLANTHERBAL_110000 B
 ON A.ID = B.PLANTID) a on t.plantid=a.id  where not isNull(t.PLANTID)) A LEFT JOIN BIZ_HERBALINFO B ON A.HERBALID=B.HERBALID)AS A LEFT JOIN BIZ_SOURCEINFO B ON 
A.SOURCEID=B.SOURCEID)AS A LEFT JOIN DIC_SUBJECTTYPE B ON A.SUBJECTID=B.ID)AS A LEFT JOIN DIC_SAMPLETYPE B ON A.SAMPLETYPE=B.ID)AS A LEFT JOIN DIC_RESOURCETYPE B ON 
A.RESOURCETYPE=B.ID)AS A LEFT JOIN DIC_FREQUENCYTYPE B ON A.FREQUENCYTYPE=B.ID)AS A LEFT JOIN DIC_PLANTTYPE B ON A.PLANTTYPE=B.ID)AS A LEFT JOIN DIC_LIFEFORMTYPE B ON 
A.LIFEFORMTYPE=B.ID)AS A LEFT JOIN DIC_WATERTYPE B ON A.WATERTYPE=B.ID)AS A LEFT JOIN DIC_LIGHTTYPE B ON A.LIGHTTYPE=B.ID)AS A LEFT JOIN DIC_AGROTYPE B ON A.AGROTYPE=B.ID)AS A 
LEFT JOIN DIC_TEMPERATURETYPE B ON A.TEMPERATURETYPE=B.ID union all SELECT A.*,TYPENAME AS TEMPERATURETYPENAME FROM(SELECT A.*,TYPENAME AS AGROTYPENAME FROM(SELECT A.*,TYPENAME AS LIGHTTYPENAME FROM(SELECT A.*,TYPENAME AS WATERTYPENAME FROM(SELECT A.*,TYPENAME AS LIFEFORMTYPENAME FROM(SELECT A.*,TYPENAME AS PLANTTYPENAME FROM(SELECT A.*,TYPENAME AS FREQUENCYTYPENAME FROM(SELECT A.*,TYPENAME AS RESOURCETYPENAME FROM(SELECT A.*,B.TYPENAME AS SAMPLETYPENAME FROM(SELECTA.ID,A.SAMPLETYPE,A.RESOURCETYPE,A.FREQUENCYTYPE,A.PLANTTYPE,A.LIFEFORMTYPE,A.PLANTHEIGHT,A.DIAMETER,A.WATERTYPE,A.LIGHTTYPE,A.AGROTYPE,A.TEMPERATURETYPE,A.SOURCELATIN,
A.GENUSNAME,A.COLLECTID,A.PLANTNUM,A.COLLECTPEOPLE,A.COLLECTDATE,A.COLLECTPLACE,A.LONGITUDE,A.LATITUDE,A.ALTITUDE,A.UTILIZATION,A.THREATENED,A.REMARK,A.CHECKUP,A.ROOT,
A.PICROOT,A.PICCAUDEX,A.FOLIAGE,A.PICFOLIAGE,A.BUD,A.PICBUD,A.BLOOM,A.PICBLOOM,A.FRUIT,A.PICFRUIT,A.SEED,A.PICSEED,A.FUNADDAPP,A.WORKINGPEOPLE,A.JOBOPERATION,A.KEYPROGRAM,A.PLANTID,A.WEIGHTID,A.FIELDID,A.TRADITONALID,A.WEIGHT,A.SOURCEID,A.SUBJECTID,A.HERBALID,A.ALIASNAME,A.HERBALPART,A.HERBALNAME,A.SOURCETYPE,A.PLANTNAMEA.PLANTLATIN,B.TYPENAME AS SUBJECTNAME FROM(SELECT A.*,B.SOURCETYPE,B.PLANTNAME,B.PLANTLATIN,B.SUBJECTID FROM(SELECT A.*,B.HERBALNAME,B.ALIASNAME FROM (select 
t.ID,t.SAMPLETYPE,t.RESOURCETYPE,t.FREQUENCYTYPE,t.PLANTTYPE,t.LIFEFORMTYPE,t.PLANTHEIGHT,t.DIAMETER,t.WATERTYPE,t.LIGHTTYPE,t.AGROTYPE,t.TEMPERATURETYPE,t.SOURCELATIN,t.GENUSN
AME,t.COLLECTID,t.PLANTNUM,t.COLLECTPEOPLE,t.COLLECTDATE,t.COLLECTPLACE,t.LONGITUDE,t.LATITUDE,t.ALTITUDE,t.UTILIZATION,t.THREATENED,t.REMARK,t.CHECKUP,t.ROOT,t.PICROOT
,t.CAUDEX,t.PICCAUDEX,t.FOLIAGE,t.PICFOLIAGE,t.BUD,t.PICBUD,t.BLOOM,t.PICBLOOM,t.FRUIT,t.PICFRUIT,t.SEED,t.PICSEED,t.FUNADDAPP,t.WORKINGPEOPLE,t.JOBOPERATION,t.KEYPROGRAM,t.PLANTID,t.W
EIGHTID,t.FIELDID,t.TRADITONALID,t.WEIGHT,a.SOURCEID,a.HERBALID,a.HERBALPART from new_samplelist_110000 t left join data_keyplantinfo_110000 a on t.WEIGHTID=a.id where not 
isNull(t.WEIGHTID)) A LEFT JOIN BIZ_HERBALINFO B ON A.HERBALID=B.HERBALID)AS A LEFT JOIN BIZ_SOURCEINFO B ON A.SOURCEID=B.SOURCEID)AS A LEFT JOIN DIC_SUBJECTTYPE B ON 
A.SUBJECTID=B.ID)AS A LEFT JOIN DIC_SAMPLETYPE B ON A.SAMPLETYPE=B.ID)AS A LEFT JOIN DIC_RESOURCETYPE B ON A.RESOURCETYPE=B.ID)AS A LEFT JOIN DIC_FREQUENCYTYPE B ON 
A.FREQUENCYTYPE=B.ID)AS A LEFT JOIN DIC_PLANTTYPE B ON A.PLANTTYPE=B.ID)AS A LEFT JOIN DIC_LIFEFORMTYPE B ON A.LIFEFORMTYPE=B.ID)AS A LEFT JOIN DIC_WATERTYPE B ON 
A.WATERTYPE=B.ID)AS A LEFT JOIN DIC_LIGHTTYPE B ON A.LIGHTTYPE=B.ID)AS A LEFT JOIN DIC_AGROTYPE B ON A.AGROTYPE=B.ID)AS A LEFT JOIN DIC_TEMPERATURETYPE B ON 
A.TEMPERATURETYPE=B.ID union all SELECT A.*,TYPENAME AS TEMPERATURETYPENAME FROM(SELECT A.*,TYPENAME AS AGROTYPENAME FROM(SELECT A.*,TYPENAME AS LIGHTTYPENAME FROM(SELECT 
A.*,TYPENAME AS WATERTYPENAME FROM(SELECT A.*,TYPENAME AS LIFEFORMTYPENAME FROM(SELECT A.*,TYPENAME AS PLANTTYPENAME FROM(SELECT A.*,TYPENAME AS FREQUENCYTYPENAME FROM(SELECT 
A.*,TYPENAME AS RESOURCETYPENAME FROM(SELECT A.*,B.TYPENAME AS SAMPLETYPENAME FROM(SELECT 
A.ID,A.SAMPLETYPE,A.RESOURCETYPE,A.FREQUENCYTYPE,A.PLANTTYPE,A.LIFEFORMTYPE,A.PLANTHEIGHT,A.DIAMETER,A.WATERTYPE,A.LIGHTTYPE,A.AGROTYPE,A.TEMPERATURETYPE,A.SOURCELATIN,
A.GENUSN
AME,A.COLLECTID,A.PLANTNUM,A.COLLECTPEOPLE,A.COLLECTDATE,A.COLLECTPLACE,A.LONGITUDE,A.LATITUDE,A.ALTITUDE,A.UTILIZATION,A.THREATENED,A.REMARK,A.CHECKUP,A.ROOT
,A.PICROOT,A.CAUDE
X,A.PICCAUDEX,A.FOLIAGE,A.PICFOLIAGE,A.BUD,A.PICBUD,A.BLOOM,A.PICBLOOM,A.FRUIT,A.PICFRUIT,A.SEED,A.PICSEED,A.FUNADDAPP,A.WORKINGPEOPLE,A.JOBOPERATION
,A.KEYPROGRAM,A.PLANTID,A.W
EIGHTID,A.FIELDID,A.TRADITONALID,A.WEIGHT,A.SOURCEID,A.SUBJECTID,A.HERBALID,A.ALIASNAME,A.HERBALPART,A.HERBALNAME,A.SOURCETYPE,A.PLANTNAME
,A.PLANTLATIN,B.TYPENAME AS SUBJECTNAME FROM(SELECT A.*,B.SOURCETYPE,B.PLANTNAME,B.PLANTLATIN,B.SUBJECTID FROM(SELECT A.*,B.HERBALNAME FROM(select 
t.ID,t.SAMPLETYPE,t.RESOURCETYPE,t.FREQUENCYTYPE,t.PLANTTYPE,t.LIFEFORMTYPE,t.PLANTHEIGHT,t.DIAMETER,t.WATERTYPE,t.LIGHTTYPE,t.AGROTYPE,t.TEMPERATURETYPE,t.SOURCELATIN,
t.GENUSN
AME,t.COLLECTID,t.PLANTNUM,t.COLLECTPEOPLE,t.COLLECTDATE,t.COLLECTPLACE,t.LONGITUDE,t.LATITUDE,t.ALTITUDE,t.UTILIZATION,t.THREATENED,t.REMARK,t.CHECKUP,t.ROOT
t.PICROOT,t.CAUDEX,t.PICCAUDEX,t.FOLIAGE,t.PICFOLIAGE,t.BUD,t.PICBUD,t.BLOOM,t.PICBLOOM,t.FRUIT,t.PICFRUIT,t.SEED,t.PICSEED,t.FUNADDAPP,t.WORKINGPEOPLE,t.JOBOPERATION,t.KEYPROGRAM,t.PLANTID,t.WEIGHTID,t.FIELDID,t.TRADITONALID,t.WEIGHT,t.ALIASNAME,a.SOURCEID,a.HERBALID,a.HERBALPART from new_samplelist_110000 t left join DATA_PFIELDSURVEY_110000 a on t.FIELDID=a.id 
where not isNull(t.FIELDID)) A LEFT JOIN BIZ_HERBALINFO B ON A.HERBALID=B.HERBALID)AS A LEFT JOIN BIZ_SOURCEINFO B ON A.SOURCEID=B.SOURCEID)AS A LEFT JOIN DIC_SUBJECTTYPE B ON 
A.SUBJECTID=B.ID)AS A LEFT JOIN DIC_SAMPLETYPE B ON A.SAMPLETYPE=B.ID)AS A LEFT JOIN DIC_RESOURCETYPE B ON A.RESOURCETYPE=B.ID)AS A LEFT JOIN DIC_FREQUENCYTYPE B ON 
A.FREQUENCYTYPE=B.ID)AS A LEFT JOIN DIC_PLANTTYPE B ON A.PLANTTYPE=B.ID)AS A LEFT JOIN DIC_LIFEFORMTYPE B ON A.LIFEFORMTYPE=B.ID)AS A LEFT JOIN DIC_WATERTYPE B ON 
A.WATERTYPE=B.ID)AS A LEFT JOIN DIC_LIGHTTYPE B ON A.LIGHTTYPE=B.ID)AS A LEFT JOIN DIC_AGROTYPE B ON A.AGROTYPE=B.ID)AS A LEFT JOIN DIC_TEMPERATURETYPE B ON 
A.TEMPERATURETYPE=B.ID UNION ALL  SELECT A.*,TYPENAME AS TEMPERATURETYPENAME FROM(SELECT A.*,TYPENAME AS AGROTYPENAME FROM(SELECT A.*,TYPENAME AS LIGHTTYPENAME FROM(SELECT 
A.*,TYPENAME AS WATERTYPENAME FROM(SELECT A.*,TYPENAME AS LIFEFORMTYPENAME FROM(SELECT A.*,TYPENAME AS PLANTTYPENAME FROM(SELECT A.*,TYPENAME AS FREQUENCYTYPENAME FROM(SELECT 
A.*,TYPENAME AS RESOURCETYPENAME FROM(SELECT A.*,B.TYPENAME AS SAMPLETYPENAME FROM(SELECT
A.ID,A.SAMPLETYPE,A.RESOURCETYPE,A.FREQUENCYTYPE,A.PLANTTYPE,A.LIFEFORMTYPE,A.PLANTHEIGHT,A.DIAMETER,A.WATERTYPE,A.LIGHTTYPE,A.AGROTYPE,A.TEMPERATURETYPE,A.SOURCELATIN,A.GENUSN
AME,A.COLLECTID,A.PLANTNUM,A.COLLECTPEOPLE,A.COLLECTDATE,A.COLLECTPLACE,A.LONGITUDE,A.LATITUDE,A.ALTITUDE,A.UTILIZATION,A.THREATENED,A.REMARK,A.CHECKUP,A.ROOT,A.PICROOT,A.CAUDE
X,A.PICCAUDEX,A.FOLIAGE,A.PICFOLIAGE,A.BUD,A.PICBUD,A.BLOOM,A.PICBLOOM,A.FRUIT,A.PICFRUIT,A.SEED,A.PICSEED,A.FUNADDAPP,A.WORKINGPEOPLE,A.JOBOPERATION,A.KEYPROGRAM,A.PLANTID,A.WEIGHTID,A.FIELDID,A.TRADITONALID,A.WEIGHT,A.SOURCEID,A.SUBJECTID,A.HERBALID,A.ALIASNAME,A.HERBALPART,A.HERBALNAME,A.SOURCETYPE,A.PLANTNAME,A.PLANTLATIN,B.TYPENAME AS 
SUBJECTNAME FROM(SELECT A.*,B.SOURCETYPE,B.PLANTNAME,B.PLANTLATIN,B.SUBJECTID FROM(SELECT A.*,B.HERBALNAME FROM(select t.ID,t.SAMPLETYPE,t.RESOURCETYPE,t.FREQUENCYTYPE,t.PLANTTYPE,t.LIFEFORMTYPE,t.PLANTHEIGHT,t.DIAMETER,t.WATERTYPE,t.LIGHTTYPE,t.AGROTYPE,t.TEMPERATURETYPE,t.SOURCELATIN,t.GENUSNA
ME,t.COLLECTID,t.PLANTNUM,t.COLLECTPEOPLE,t.COLLECTDATE,t.COLLECTPLACE,t.LONGITUDE,t.LATITUDE,t.ALTITUDE,t.UTILIZATION,t.THREATENED,t.REMARK,t.CHECKUP,t.ROOT,t.PICROOT,t.CAUDE
X,t.PICCAUDEX,t.FOLIAGE,t.PICFOLIAGE,t.BUD,t.PICBUD,t.BLOOM,t.PICBLOOM,t.FRUIT,t.PICFRUIT,t.SEED,t.PICSEED,t.FUNADDAPP,t.WORKINGPEOPLE,t.JOBOPERATION,t.KEYPROGRAM,t.PLANTID,t.W
EIGHTID,t.FIELDID,t.TRADITONALID,t.WEIGHT,a.SOURCEID,a.HERBALID,a.HERBALPART,a.ALIAS1 as ALIASNAME from new_samplelist_110000 t left join DATA_TRADITONAL_110000 a on 
t.TRADITONALID=a.id where not isNull(t.TRADITONALID)) A LEFT JOIN BIZ_HERBALINFO B ON A.HERBALID=B.HERBALID)AS A LEFT JOIN BIZ_SOURCEINFO B ON A.SOURCEID=B.SOURCEID)AS A LEFT
JOIN DIC_SUBJECTTYPE B ON A.SUBJECTID=B.ID)AS A LEFT JOIN DIC_SAMPLETYPE B ON A.SAMPLETYPE=B.ID)AS A LEFT JOIN DIC_RESOURCETYPE B ON A.RESOURCETYPE=B.ID)AS A LEFT JOIN 
DIC_FREQUENCYTYPE B ON A.FREQUENCYTYPE=B.ID)AS A LEFT JOIN DIC_PLANTTYPE B ON A.PLANTTYPE=B.ID)AS A LEFT JOIN DIC_LIFEFORMTYPE B ON A.LIFEFORMTYPE=B.ID)AS A LEFT JOIN
DIC_WATERTYPE B ON A.WATERTYPE=B.ID)AS A LEFT JOIN DIC_LIGHTTYPE B ON A.LIGHTTYPE=B.ID)AS A LEFT JOIN DIC_AGROTYPE B ON A.AGROTYPE=B.ID)AS A LEFT JOIN DIC_TEMPERATURETYPE B ON
A.TEMPERATURETYPE=B.ID) where ID like '*110228*'  
最后告诉我语法错误操作符丢失，在t.caudex位置处
求解决。。。