I've used SOQL to successfully build a relationship between my main object and child objects through a junction object. Each of those children has children, so I want to use the SOQL relationship to replicate a table (which works) and a second SOQL relationship to replicate the grandchildren as rows. However, only the same grandchild record is replicated in the tables.
So it should be Table A has row a and Table B has row b, but what I have is Table A row a and Table B row a.
Does that make sense? Any guidance is appreciated!