用子查询:
SLEECT * FROM (
select a.ITEM_NO,a.CUST_ID,a.EFFECTIVE_DATE,a.EXPIRY_DATE,a.PRICE,b.ITEM_DESC,b.ITEM_GROUP,b.STAT_GROUP,b.STD_COST,b.FAMILY_ID,c.TITLE,c.CURR
from TPMTRPRICE a,TPMITEM b,TPMCUSTOMER c
where a.ITEM_NO=b.ITEM_NO
and a.CUST_ID=c.CUST_ID
and trunc(a.EFFECTIVE_DATE)<= sysdate
and trunc(a.EXPIRY_DATE) >= sysdate
and upper(a.CUST_ID)>='B56821'
and upper(a.CUST_ID)<='E56735' ) D
ORDER BY ITEM_NO
SLEECT * FROM (
select a.ITEM_NO,a.CUST_ID,a.EFFECTIVE_DATE,a.EXPIRY_DATE,a.PRICE,b.ITEM_DESC,b.ITEM_GROUP,b.STAT_GROUP,b.STD_COST,b.FAMILY_ID,c.TITLE,c.CURR
from TPMTRPRICE a,TPMITEM b,TPMCUSTOMER c
where a.ITEM_NO=b.ITEM_NO
and a.CUST_ID=c.CUST_ID
and trunc(a.EFFECTIVE_DATE)<= sysdate
and trunc(a.EXPIRY_DATE) >= sysdate
and upper(a.CUST_ID)>='B56821'
and upper(a.CUST_ID)<='E56735' ) D
ORDER BY ITEM_NO
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货