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