GROUP BY ALL, in MySQL

[Guillermo Mendoza]

I'm using this query:

select FlTdate Fecha, count(TotBoarded) Vuelos
from transactions
where TxnAmount = 0
and TotBoarded <> 0
and Origin = 'JFK'
group by all FltDate
having FltDate between '2005-10-16' and '2005-10-29'
order by FltDate

But when conditions are not fullfilled, I get an empty row (a.k.a. nothing). But then, I need a zero on that row.

GROUP BY ALL worked, but MySQL doesn't include this function. Any ideas on how to do it?

Thx