3路内连接查询表达式中的语法错误(缺少操作符)

Question

我看到了以下错误消息:在将以下查询写入我的程序时，查询表达式'm.AccountNumber=a.AccountNumber in ActivityTable_2M b On a.AccountNumber = b.AccountNumber'中出现了以下语法错误(缺少操作符)：

SELECT m.CaseManager, SUM(m.Lead) AS 'Total Leads', 
COUNT(a.Description) AS 'Total Activity', 
COUNT(b.Description) AS 'Total Activity (T-2 Months)', 
Sum(IIF(a.Description Like 'Outgoing Call%',1,0)) As 'Outbound Calls', 
Sum(IIF(b.Description Like 'Outgoing Call%',1,0)) As 'Outbound Calls (T-2 Months)', 
Sum(IIF(a.Description Like 'Credit%',1,0)) As 'Credit', 
Sum(IIF(b.Description Like 'Credit%',1,0)) As 'Credit (T-2 Months)', 
Sum(IIF(a.Description Like 'Correspondence Sent%',1,0)) As 'Correspondence', 
Sum(IIF(b.Description Like 'Correspondence Sent%',1,0)) As 'Correspondence (T-2 Months)' 
FROM AccountTable m INNER JOIN ActivityTable a ON m.AccountNumber=a.AccountNumber 
INNER JOIN ActivityTable_2M b On a.AccountNumber = b.AccountNumber 
GROUP BY m.CaseManager;

在添加第二个内部联接(ActivityTable_2M)之前，查询运行得很好，因此我假设这里有一个问题。我在SQL测试器上运行了这个查询，没有突出显示错误。

Answer 1

在access中，使用多个联接时需要使用括号()。请试试这个：

SELECT m.CaseManager, SUM(m.Lead) AS 'Total Leads', 
COUNT(a.Description) AS 'Total Activity', 
COUNT(b.Description) AS 'Total Activity (T-2 Months)', 
Sum(IIF(a.Description Like 'Outgoing Call%',1,0)) As 'Outbound Calls', 
Sum(IIF(b.Description Like 'Outgoing Call%',1,0)) As 'Outbound Calls (T-2 Months)', 
Sum(IIF(a.Description Like 'Credit%',1,0)) As 'Credit', 
Sum(IIF(b.Description Like 'Credit%',1,0)) As 'Credit (T-2 Months)', 
Sum(IIF(a.Description Like 'Correspondence Sent%',1,0)) As 'Correspondence', 
Sum(IIF(b.Description Like 'Correspondence Sent%',1,0)) As 'Correspondence (T-2 Months)' 
FROM (AccountTable m INNER JOIN ActivityTable a ON m.AccountNumber=a.AccountNumber) 
INNER JOIN ActivityTable_2M b On a.AccountNumber = b.AccountNumber 
GROUP BY m.CaseManager;

Answer 2

在access中，如果不使用括号将它们分隔开，就不能有多个联接。参考资料：Here