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