问microsoft access数据库引擎找不到输入表或查询“Test”。确保它存在，并且其名称拼写正确

EN

the Microsoft access database engine cannot find the input table or query 'Test'. 
Make sure it exists and that its name is spelled correctly.

SELECT 
      TEST.[CATEGORY CODE] AS CATEGORYCODE
    , TEST.[SAMPLE COMPOSITION] AS SAMPLECOMPOSITION
    , Sum(TEST.[WPI]) AS [SumOfWPI]
    , Sum(TEST.[Mean Freq Year Fav]) AS [SumOfMean Freq Year Fav] 
FROM 
(
    SELECT * 
    FROM DATA1 
    WHERE DATA1.[CATEGORY CODE] IN (
            SELECT DISTINCT CODES.[CATEGORY CODE] 
            FROM CODES
        ) 

    UNION ALL 

    SELECT * 
    FROM DATA2 
    WHERE DATA2.[CATEGORY CODE] IN (
            SELECT DISTINCT CODES.[CATEGORY CODE] 
            FROM CODES
        ) 
) AS TEST 
WHERE TEST.[COUNTRY] = 'UNITED STATES' 
    AND TEST.[SAMPLE COMPOSITION] IN (
        SELECT DISTINCT TEST.[SAMPLE COMPOSITION] 
        FROM TEST
    ) 
    AND TEST.[CATEGORY CODE] IN (
        SELECT DISTINCT CODES.[CATEGORY CODE] 
        FROM CODES
    ) 
GROUP BY TEST.[CATEGORY CODE], TEST.[SAMPLE COMPOSITION] 
ORDER BY TEST.[CATEGORY CODE];