select a.BEGIN_DATE,a.END_DATE,a.SERVICECODE,b.SERVICENAME
from
(select BEGIN_DATE,END_DATE,SERVICECODE,GATEWAY
from EP_CONT_CUSTOM
where CP_SVCID in(
select CP_SVCID from CP_SERVICE
where CP_ID=CP_ID)
and BEGIN_DATE between to_date('20050101','yyyymmdd') and to_date('20061231','yyyymmdd')) a,SERVICEINFO b
where a.SERVICECODE=b.SERVICECODE
and a.GATEWAY=b.GATEWAY
from
(select BEGIN_DATE,END_DATE,SERVICECODE,GATEWAY
from EP_CONT_CUSTOM
where CP_SVCID in(
select CP_SVCID from CP_SERVICE
where CP_ID=CP_ID)
and BEGIN_DATE between to_date('20050101','yyyymmdd') and to_date('20061231','yyyymmdd')) a,SERVICEINFO b
where a.SERVICECODE=b.SERVICECODE
and a.GATEWAY=b.GATEWAY
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货