ustedes que le saben mas denme u nore de por donde esta el error en mi consulta pls
(SELECT DATE_FORMAT(cdr.calldate,concat('%d %M %Y')) AS fecha, mike.ext FROM cdr LEFT JOIN ( SELECT DATE_FORMAT(cdr.calldate,concat('%d %M %Y')) AS fecha, COUNT(cdr.dstchannel) AS ext FROM cdr WHERE YEAR(cdr.calldate) = 2010 AND MONTH(cdr.calldate) = 3 AND cdr.disposition = 'ANSWERED' AND cdr.duration > 60 AND cdr.dstchannel LIKE 'SIP/102%' GROUP BY fecha ORDER BY fecha ASC )AS mike ON consulta.fecha = mike.fecha WHERE YEAR(cdr.calldate) = 2010 AND MONTH(cdr.calldate) = 3 AND cdr.disposition = 'ANSWERED' AND cdr.duration > 60 GROUP BY fecha ORDER BY fecha ASC )AS consulta
GRACIAS DE ANTE MANO