Anyidea why not ? or solution

[helo worl]

mysql> select agentid,compid,pin,destno,blegzone,duration,
-> (
-> select rate from agentcost,
-> (
-> select rate1 from agentprofile,agent where
-> agentprofile.agentid=cdr.agentid and profile=wk_profile and agent.agentid=cdr.agentid and agent.agentid=cdr.agentid and hour2>=left(cdr.time,2) limit 1
-> ) ratetmp
-> where agentid=cdr.agentid and rateid = ratetmp.rate and c_code=substr(cdr.destno,1,agentcost.c_code_len) limit 1
-> ) as cost
-> from cdr where date='03/11/2005' and duration>0 limit 1;

ERROR 1109 (42S02): Unknown table 'cdr' in where clause
mysql>