Thanks OpenOffice 1.0 or 1.1 + UnixODBC+MyODBC+MySQL group

[Alain Dallo]

Thank you very much Bilma to your help.

Sum(1) instead of Count(*) is a good workaround to the next problem.

Supposedly, it must group registers by one field and count grouped registers in
the second field, but it just returns the result to the first field and nothing or 0 to the second.
SELECT `PROFESSION`, COUNT( `PROFESSION` ) AS `nb` FROM `cretins` `cretins` GROUP BY `PROFESSION`
Bye.
Alain Dallo
adallo@univ-paris1.fr