hello
I have a problem with this task
it is absolutely right, but since MS Acces 2003 is not supported for the DISTINCT after COUNT
our teacher want us to do the task in a Other Way
does anyone have any suggestions?

This is the relationship model
ImageShack® - Online Photo and Video Hosting

and here is the right code which only do not work in ms acces:

SELECT p.personnummer, p.namn, p.ort FROM Person p INNER JOIN Lärare l ON l.personnummer = p.personnummer WHERE p.personnummer IN ( SELECT personnummer

FROM Kurstillfälle, Lärare

WHERE lärare=personnummer

GROUP BY personnummer

HAVING Count (rum) > 2 );


and the question was : Select the nummer, namn and ort from lärare who have kept (coursesessions =Kurstillfälle) for at least three
VARIOUS rum