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