>When GROUP BY is used you can only include in the column list columns listed in GROUP BY or aggregate functions.

As per my last rely to Carole, I tried that and it doesn't work either. That's the one I tried:

SELECT TOP 40 New.Numero,New.Type,New.Titre,New.Message,New.Month,New.Year,New.Page,;
 New.Url,New.Creation,New.Titre_P,New.Titre_S,New.Message_P,New.Message_S FROM New;
 INNER JOIN NewAll ON New.Numero=NewAll.NoNews;
 WHERE NewAll.NoClient=tnZone AND New.Status=1 AND (NOT INLIST(New.Type,7,10) OR;
 (New.Type=7 AND New.Date>=ldDateEvent) OR;
 (New.Type=10 AND New.Date<=ldDateEvent AND New.DateFin>=ldDateEvent));
UNION;
SELECT New.Numero,New.Type,New.Titre,New.Message,New.Month,New.Year,New.Page,;
 New.Url,New.Creation,New.Titre_P,New.Titre_S,New.Message_P,New.Message_S FROM New;
 INNER JOIN New AS New2 ON New.NoUserGrou=New2.Numero;
 INNER JOIN NewAll ON New2.Numero=NewAll.NoNews;
 WHERE NewAll.NoClient=tnZone AND New.Status=1 AND INLIST(New.Type,13,15) AND;
  LEN(New.Message)>100;
 GROUP BY New.Numero,New.Type,New.Titre,New.Message,New.Month,New.Year,New.Page,;
  New.Url,New.Creation,New.Titre_P,New.Titre_S,New.Message_P,New.Message_S
 ORDER BY 9 DESC INTO CURSOR Temp

Can you provide the proper syntax in this case?