Retrieving children that does not fit in search request

Can you explain more on this? I’ve seen on other support tickets it was said that it was not possible. If i have the service details, how do I work up to the House table that it belongs to?

For the fix, I tried that in the beginning and had this same issue. I thought using the ‘having’ clause would fix it since Houses → Openings and Openings → Services are 1:N. Here is what I am receiving.