>>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?

It looks correct to me. Would it work if you ran just second select?