Returning parent table when querying databases - codeless

I have a DB like this

I want to query and pull all houses (with relating openings and services) by the agentId. Being that a house can have multiple openings, I need to keep the agentId in the Opening table. How do I pull all this information using a codeless block? Or is my implementation totally wrong?

If I correctly understood you, here you go:

Oh wow that is super simple. I was way overthinking it. Thank you!

1 Like