一个非常奇怪的问题

[Corn1]

表结构：
create table T_O_TopNDisconnect
(
ID number(10) not null,
EventID number(10) null,
JobDetailID number(10) default 13201 not null,
MissionID number(10) null,
ZoneID number(10) null,
TimeStamp date not null,
SectorName varchar2(100) not null,
SectorOID varchar2(50) not null,
BoardCount number(10) not null,
BusiDiscRate number(10,4) not null,
BusiDiscCount number(10) not null,
CallSuccCount number(10) not null,
BecallSuccCount number(10) not null,
DiscInterval number(10,4) not null,
BussCallCount number(10,4) not null,
CurrDate date null,
ColorID number(1) default 0 not null,
CheckBoardCount number(10) default 0 not null,
DealDate date null,
DealValue number(10,4) null,
DealProgressID number(1) default 1 not null,
OperatorID number(10) null,
Analyze varchar2(500) null,
AuditResult number(1) default 0 not null,
AuditTime date null,
AuditOperatorID number(10) null,
AuditRemark varchar2(500) null
)
tablespace NOMSSPACE;

我现在需要更新CheckBoardCount字段，值为该SectorOID的过去6天内（包括当天），BusiDiscRate>2.5的天数。
同样的一段话：
update T_O_TopNDisconnect a set CheckBoardCount=(select count(*) from (select distinct CurrDate from T_O_TopNDisconnect b where (b.CurrDate between a.CurrDate-6 and a.CurrDate) and (b.BusiDiscRate>2.5) and (b.SectorOID=a.SectorOID)))
where exists (select 1 from T_O_TopNDisconnect b where (b.CurrDate between a.CurrDate-6 and a.CurrDate) and (b.BusiDiscRate>2.5) and (b.SectorOID=a.SectorOID) and a.AuditResult=0);
在oracle10g中执行成功，但11g，报错：
ORA-00904: "A"."SECTOROID": 标识符无效

请问是什么原因？

[bw555]

update T_O_TopNDisconnect a
set CheckBoardCount=(select count(distinct CurrDate) from T_O_TopNDisconnect b
    where (b.CurrDate between a.CurrDate-6 and a.CurrDate) and (b.BusiDiscRate>2.5) and (b.SectorOID=a.SectorOID))
where exists (select 1 from T_O_TopNDisconnect b
    where (b.CurrDate between a.CurrDate-6 and a.CurrDate) and (b.BusiDiscRate>2.5) and (b.SectorOID=a.SectorOID) and a.AuditResult=0);

子查询层级太多了，最里面已经不能访问最外层的表名了吧 可以用count(distinct CurrDate)去掉一层子查询