我想是因为取数据范围不清楚造成的.
sum(g.GatheringNumber) from ARM_Gatheringlist g,
CMRC_Arealist a,
CMRC_Customers c
where
c.AreaId=a.Areaid
and g.customerid=c.customerid
这句话用左连接和in子句改写为:
.....
sum(g.GatheringNumber) from ARM_Gatheringlist g
left join CMRC_Customers c on g.customerid=c.customerid
where c.AreaId in (select AreaId from CMRC_Arealist )
sum(g.GatheringNumber) from ARM_Gatheringlist g,
CMRC_Arealist a,
CMRC_Customers c
where
c.AreaId=a.Areaid
and g.customerid=c.customerid
这句话用左连接和in子句改写为:
.....
sum(g.GatheringNumber) from ARM_Gatheringlist g
left join CMRC_Customers c on g.customerid=c.customerid
where c.AreaId in (select AreaId from CMRC_Arealist )
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货