hibernate - HQL and one-to-many queries -
I have hibernate domain objects that look like this: class player {list & Gt; Items & gt; ; List; } Category item {list & lt; Attraction & gt; Sorcery; } Class exchanges {Boolean supplementary enchantment; } I need to create a HQL query that gives me a list of all the players who have at least one item on which there is a charm in which IsuperiorEnchantment is the flag set I can not understand a way of expressing it in HQL for my life. Any thoughts? Considering the appropriate mapping on all of the above, the query you are looking for is: