单独使用
act_projecttype='M' and act_atadestnport<=act_etadate 条件
或单独使用
(trunc((t2ashipmentno_KPI.Act_Atamit - to_date(t2ashipmentno_kpi.act_insertdate||' 23:00','dd-mon-yy hh24:mi')) * 24,0)<t2aleadtime.lead_time and t2ashipmentno_kpi.act_shipfrom_province = t2aleadtime.from_province
AND t2ashipmentno_kpi.act_shipfrom_city=t2aleadtime.from_city AND t2ashipmentno_kpi.act_province1=t2aleadtime.to_province and act_projecttype='C')
都没有问题
act_projecttype='M' and act_atadestnport<=act_etadate 条件
或单独使用
(trunc((t2ashipmentno_KPI.Act_Atamit - to_date(t2ashipmentno_kpi.act_insertdate||' 23:00','dd-mon-yy hh24:mi')) * 24,0)<t2aleadtime.lead_time and t2ashipmentno_kpi.act_shipfrom_province = t2aleadtime.from_province
AND t2ashipmentno_kpi.act_shipfrom_city=t2aleadtime.from_city AND t2ashipmentno_kpi.act_province1=t2aleadtime.to_province and act_projecttype='C')
都没有问题
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货