Unanswered: "outer join" --> not getting all wanted results
I'm having 2 tables :
Table 1 (consists all features):
feat (code to be linked with table1)
What i want : all feats from table1 and, if existing, the count for the feat from table2 (so if Table1 has 9 records and Table2 has 8, I want 9 records, of which 8 with count, 1 without count)
Problem is, I only get 8 records.
The sql (a bit more fields than in above example but ...)
SELECT FeatClass.Country, qryPOICategories.category, FeatClass.Featclass, FeatClass.Featname, Sum(FeatClass.Count) AS sumCount, Sum(FeatClass.PreviousCount) AS sumPreviousCount, Sum([count]-[previouscount]) AS Difference
FROM qryPOICategories LEFT JOIN FeatClass ON qryPOICategories.feat = FeatClass.Featclass
GROUP BY FeatClass.Country, qryPOICategories.category, FeatClass.Featclass, FeatClass.Featname;
With qryPOICategories serving as Table1, featclass serving as Table2.
Problem is with some countries, I get 4 feats in a category, other countries I get 7 feats.