这样写的sql语句有无问题

flyabout

sql的高手看看,下面的语句是否有问题,客户反应长世界没结果
  select sum(a.MB_IN_AREA_FEE)
from FACT_ACCT_ITEM_CUST_919_200804 a
where exists ( select 1 from FACT_CUST_INFO_919_200804 b
where  a.cust_id=b.cust_id and b.SERVICE_PRPTY_ID =12 and b.BRAND_FLAG_1  =1 and b.STS ='A');

iwantin

db2advis 检查一下索引，可能是索引没有建好

dlms

试试就知道了

[ 本帖最后由 dlms 于 2008-6-16 12:59 编辑 ]

fleeting

select sum(a.MB_IN_AREA_FEE) from
FACT_ACCT_ITEM_CUST_919_200804 a left join
(select distinct cust_id from FACT_CUST_INFO_919_200804 where SERVICE_PRPTY_ID = 12 and BRAND_FLAG_1 = 1 and STS ='A') b
on a.cust_id = b.cust_id
where b.cust_id is not null