>>You can use first query as a derived table.
>>
SELECT News.Numero, News.CustomerName FROM ( ;
>> SELECT MIN(News.Numero) AS Numero FROM News WHERE Priority=1 ) Temp
>> INNER JOIN News ON Temp.Numero = News.Numero
>
>Thanks, this is what I was looking for. I'll try that. In my original message, I forgot to include the GROUP BY clause in the first SQL. But, I guess this approach can still work.
Yes, it'll.
--sb--