Inner Join problem

Hi there,

I'm having abit of trouble creating a query that takes a result set and adds an additional column (or replaces it) using either JOIN or SELECT INTO query. Here's what I tried:

Original query that selects top 5 most populated academic section (i.e. those that have most staff)
SELECT TOP 5 Staff.WorksIn AS [Section], COUNT(*) AS [Staff Count]
FROM Staff, AcademicSection
WHERE (((AcademicSection.[ASId])=[WorksIn]))
GROUP BY Staff.WorksIn
ORDER BY Count(*) DESC;

Now I need to get and add in AcademicSection.LongName into it, replacing [Section] or using it to acquire corresponding LongName. How would I do that, please? I tried this:

SELECT LongName FROM AcademicSection INNER JOIN (SELECT TOP 5 Staff.WorksIn AS [Section], COUNT(*) AS [Staff Count]
FROM Staff, AcademicSection
WHERE (((AcademicSection.[ASId])=[WorksIn]))
GROUP BY Staff.WorksIn
ORDER BY Count(*) DESC) ON AcademicSection.[ASId] = [Section];

But it doesn't work saying that JOIN expression is not supported.

swampBoogie, thanks!
I really feel stupid here, I guess the only punishment strong enough is to ... practice more SQL queries!