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