I am executing the following query (minimized):



Now when I execute this, all goes well... except that "things" is supposed to be a set with 3 objects in it.
Instead it only has 1 object in it (the first one encountered in de database).
Same goes for "others", that only has 1 object.

I've searched a bit but can't find a solution for this, anyone knows what I am doing wrong?

thanks

Ok i found out why.
Further down the "tree" inside the database, I had some normal join fetches, but if I put a left join instead it works for some reason.
Don't know why since there are values populated for all the tables down the tree.