Hi Cefi Org,
So in the current set up, you are getting duplication because of the many-to-many relationship of the region/district/province, you could do the inner join to obtain the correct access point value:
However the population seems lower, probably because of a name mismatch in one of the joining fields.
Hope this helps a little.
I tried all possible join configuration (including inner join) but I still have my overcounting problem.
Is there a way to resolve the overcounting problem with joins or should I use Data Blending?
Changing CNT to COUNTD (count distinct) should resolve the first problem, but you definitely have a bigger problem on your hand. I'd really suggest that you take a step back and explain to us what you are trying to do here. Provide some details on each of the tables you're joining, along with what exactly you're trying to do. Then we'll be better informed to provide the best solution.