DISTINCT SQL Problem

[JohannIcon]

Dear All,

I have a query where I want to select the top 3 portfolio Items, however these must have distinct Category names. Here is the SQL which I came up with, however it is not working:-

SELECT TOP 3 portfolio.*,DISTINCT [category].[CatName] FROM portfolio INNER JOIN category ON [portfolio].[catID]=[category].[catID] ORDER BY CatName ASC, portfolioID DESC"

Can you please help me out.

Thanks