I'm having some issues with HQL since I'm a newbie with it. Even though I don't have issues with "simple queries", I am currently stuck with a query between three tables.
I already read the tutorials, but I can't find a valid example for my needs. I will do my best to explain my problem:
I have three different tables, let's name them
Given a town Id, I need to list all houses from that town, including the name and surname of that house's owner.
I made a really simple graph to show the connections between tables:
I'm also unsure on which join strategy I should use. Any kind of help would be highly appreciated, since solving this is a priority for me.
Thanks in advance!