顾客长时间没有联系提醒

1.SQL语句：

--- 获得数据列表(托运单位)
select a.V_CompName as V_CompName,a.V_ContactTel asV_ContactTel,
CONVERT(varchar(10),a.D_FromTime,120) as D_FromTime,
b.I_Days from
(select tbl_consign.V_CompName asV_CompName,tbl_consign.V_ContactTel asV_ContactTel,tbl_consign.I_Remind as I_Remind,t.D_FromTime
--V_ConComCode  托运单位代码,与托运单位表关联
--D_FromTime  起运时间
from (select V_ConComCode,max(D_FromTime) as D_FromTime fromtbl_plan  group by V_ConComCode) t
left join tbl_consign
on t.V_ConComCode = tbl_consign.I_CompCode) a,tbl_remind b
where dateadd(day,cast(b.I_Days asint),a.D_FromTime)<= getdate()
and a.I_Remind = 1 and b.v_type = '客户长时间没货' anda.D_FromTime!='1900-01-01 00:00:00.000'