Returning parent table when querying databases - codeless

[Tyler_DeLanghe]

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?

[stanislaw.grin]

If I correctly understood you, here you go:

[Tyler_DeLanghe]

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