left join 连接多张表 语法错误 求解答
想用left join 连接几张表,可是提示语法错误(操作符丢失),麻烦大侠帮忙看下下面语句错在哪里,我单独运行两张表都没有问题,放一起就提示错误了。
SELECT T1.会员编号 AS 会员编号, IIF(T1.销售日期<#2016/5/1#,1,IIF([T1].[名称(1)]=[卡种年限].[卡种名],[卡种年限].[卡种],0) AS 卡种, IIF([T1].[销售日期]<#2016/1/1#,0,IIF([手环].[字段2]=[T1].[会所]&[T1].[CMDOCO],[手环].[金额],0)) AS 手环金额
FROM (select *from [Sheet1$] IN "D:\Users\peifeng.huang\Desktop\会籍直线法 - access测试用.xlsx" "EXCEL 8.0;"
) AS T1 LEFT JOIN [手环] ON T1.[会所]&T1.[CMDOCO]=[手环].[字段2] LEFT JOIN [卡种年限] ON T1.[名称(1)]=[卡种年限].[卡种名]