outer join + Count

Det nemmeste er at bruge de indbyggede guides i Access. Lav en ny forespørgsel i designvisning, vælg dine tabeller og vælge de felter, du vil have med, så ordner Access resten. Hvis du vil have count, skal du højreklikke, vælge "Totaler" og vælge "Antal".

Undskyld men grunden til jeg stillede spørgsmålet er at jeg er ny til SQL, og forsøger at lære det men SQL'en i acces er ikke den samme som den jeg har læst om.

splosh>SQL is NOT my HOT subject but lets try and understand what it is you are trying to do! An OUTER JOIN will give you records on one side of the join and IF there is a related record it will give you one or more records on the other side of the JOIN. If there are no records on the OUTER side then you only see the information from the INNER side.
So if I am guessing correctly then you want to see th enumber of records on the OUTER side, is this correct?

So somethink like this would do the trick
SELECT DISTINCT tblInner.PrimaryKey, (select count(*) from tblOuter where ForeignKey = [tblInner]![PrimaryKey]) AS nr
FROM tblInner LEFT JOIN tblOuter ON tblInner.PrimaryKey = tblOuter.ForeignKey;

another way is to use an aggregate query

SELECT  tblInner.PrimaryKey, Count(tblOuter.ForeignKey) AS Nr
FROM tblInner LEFT JOIN tblOuter ON blInner.PrimaryKey = tblOuter.ForeignKey
GROUP BY tblInner.PrimaryKey;