I have a query which is the union of 3 queries. In which all the locations of children and grandchildren are gathered within the parent locations, that is:
- father: URG
- children: URG-01, URG-02
- grandchildren: URG-N-01, URG-N-02
with a query and a field I put all of them inside the father and I told him to give me all the father locations that at the end are 34. But he only gives me 21 because they are the only ones that have had transfers.
I do not want that, I want you to show me the 34, does anyone have any idea how to do it?