SQL语句求助

SELECT T1.C AS [客户],T1.D1 AS [DATE],T1.D2 AS [DATE2],COUNT(T2.C)AS [联系次数] FROM T1 

LEFT JOIN T2 ON T2.C = T1.C AND T2.D BETWEEN T1.D1 AND T1.D2 

GROUP BY T1.C,T1.D1,T1.D2

提示between操作符之间没有And在查询表达式中

MySQL?