I created a self-join relationship from table Account:
Table occurrence Account and table occurrence ParentAccount are connected
via Account::id = ParentAccount::id_Account
There is a record with id = 100 and id_Account = 105,
and there is a record with id = 105.
So, 105 is the parent of 100:
I can use the GTRR step to go to all the parent records of a found set.
However, at the same time I want that the child records are still in the found set. In other words: I want a found set that contains the records and their parent records.
Any idea how this can smoothly be done? :-)