hacer subconsulta??

[diegonazho]

Gracias nano me resulto de echo lo modifique a esot y funciona

Código MySQL:

SELECT calldate ,src , count(accountcode) as todas,
(SELECT count(accountcode) FROM cdr WHERE accountcode = 'entel' ) as 'entel' 
FROM cdr WHERE src = '77000' AND calldate BETWEEN '20110301' AND '20110401' and  billsec > 0
GROUP BY src DESC