hacer subconsulta??

[diegonazho]

mira segun yo... ademas que no recuerdo muchosobre consultas anidadas seria algo asi pero no me funciona

Código MySQL:

SELECT calldate ,src ,  count(accountcode) as todas,accountcode as "entel"
FROM cdr 
WHERE src = '77000'
AND calldate BETWEEN '20110301' AND '20110401'
and accountcode in (select count(accountcode) from cdr where accountcode= 'entel')
 GROUP BY src DESC