>Other way is:
>

>SELECT News.Numero, News.CustomerName, MIN(News.Numero) AS Numero FROM News ;
> Group By News.Numero, News.CustomerName
>

As per the new standard in VFP, which seems to be compatible with SQL Server, we can't no longer use that approach when having a GROUP BY. So, this is why we collect the keys first and then use a INNER JOIN in another SQL to get the rest of the fields.