Sean Lange (3/28/2013)

---

mrivero1961 (3/28/2013)

---

Thank you for help.

I've modified the query, but the output not change:

SELECT

DATE_START,

COALESCE (idDGIG, 'Tot') AS sGIG,

`NUMBER`

FROM

(

SELECT

CA.DATE_START AS DATE_START,

LEFT (CA.idDGIG, 2) AS sGIG,

COUNT(CA.idDGIG) + COUNT(A.EVENT) AS NUMBER

FROM

TABLE_LONG CA

JOIN TABLE_SHORT A ON CA.DATE_START = A.DATE_START

WHERE

CA.DATE_START = DATE_ADD(CURDATE(), INTERVAL - 1 DAY)

AND LEFT (CA.idDGIG, 2) IN ('QM', 'QI', 'QO', 'QS')

GROUP BY

LEFT (CA.idDGIG, 2) WITH ROLLUP

) AS SSS;

+-------------+--------+--------+

| DATE_START | sGIG | NUMBER |

+-------------+--------+--------+

| 2013-03-27 | QI | 468 |

| 2013-03-27 | QM | 104 |

| 2013-03-27 | QO | 312 |

| 2013-03-27 | QS | 260 |

| 2013-03-27 | Tot | 1144 |

+-------------+--------+--------+

It wasn't supposed to change the output. It is however a lot easier to read. It did provide a query that will actually work though. 😛