SELECT ID AS 联系人ID, NAME AS 姓名, PHONE AS 移动电话, T10 AS 生日, Date() AS birthday
FROM CUSTOMER WHERE T10 is not Null 
And T10 Like '%'+IIf(Month(Now())>9,CStr(Month(Now())),'0'+CStr(Month(Now())))+'月'+IIf(Day(Now())>9,CStr(Day(Now())),'0'+CStr(Day(Now())))+'日'
and PHONE not in (select CStr(号码) from 发送记录 where 
短信类型='生日问候' and CStr(号码) = CUSTOMER.PHONE
and Year(发送时间) = Year(Now()) and Month(发送时间) = Month(Now()) and Day(发送时间) = Day(Now()))