GROUP BY ALL

[Bas Manniën]

I have to migratie my queries from MSSQL (T-SQL) to MySQL.

I'm using the ALL keyword in the GROUP BY clause to get also the records which return zero.

If you use ALL, the query results include all groups produced by the GROUP BY clause, even if some of the groups have no rows that meet the search conditions. Without ALL, a SELECT statement that includes GROUP BY does not show groups for which no rows qualify.

Is there a method in MySQL to get the same result?