What is mixing me up, is this...
When I create INNER JOINS in my queries, I am used to starting with a Parent Table (e.g. SECTION) and then joining the Child, Junction Table (e.g. SECTION_DIMENSION) and then doing another INNER JOIN back to the other Parent (e.g. DIMENSION).
The point being that the "Junction Table" is what is causing the link between the Parent Tables - thus the name.
However, with your query, you were going from Child, Junction Table (i.e. SECTION_DIMENSION) up to a Parent Table (i.e. DIMENSION) and then back down to another Child, Junction Table (i.e. DIMENSION_SUBSECTION).
Because I am used to INNER JOINS consisting of joining Parent ---> Child <--- Parent, it threw me off?!
So, to be clear, could you please answer this earlier question....
But I believe this is how things actually work...
Because I already have all of the Tables "joined" together like this...
...there is NO NEED to create an *additional join* like this...
SECTION -||----|<- SECTION_DIMENSION ->|------||- DIMENSION
DIMENSION -||------|<- DIMENSION_SUBSECTION ->|-----||- SUBSECTION
SUBSECTION -||------|<- ARTICLE
SECTION_DIMENSION -||------|<- SECTION_DIMENSION_SUBSECTION ->|-------||- DIMENSION_SUBSECTION
Is that correct??