请高手帮我看看下面的代码为什么显示JOIN连接错误

SELECT RD.*
FROM [SELECT File_Version_Query.[File Information].文件编号 AS [Document No], File_Version_Query.中文名称 AS [Chinese Title], File_Version_Query.英文名称 AS [English Title], File_Version_Query.版本 AS [Rev], File_Version_Query.页数 AS [Pages], File_Version_Query.发起人 AS [Owner], File_Version_Query.申请部门 AS [Dept], File_Version_Query.状态 AS [Status], File_Version_Query.查看链接 AS [Link],   (Datevalue(File_Version_Query.生效日期)) AS [Effective Date]
FROM File_Version_Query
WHERE (File_Version_Query.生效日期 Is Not Null)]. AS RD INNER JOIN [Select (Max([生效日期])) as MD From [File_Version_Query]]. AS MDQ ON (Datevalue([RD].[Effective Date]))=(Datevalue([MDQ].[MD]));

太长了，俺有些看不下去，为什么不加上别名呢？最好还是加上附件吧。按我对Access的理解，应该是Join完再Where的。