Hi! I got this problem:

This statement returns me (just as I want) 1:


However, the Thing I really would like to know is this:


But this one gives me a count of zero when the joined collection is empty. If I look at the resulting SQL-statement I can see that the problem is that this "str.relation1.relation2" is translated into a cross join and the connection is done through an added AND-block in the WHERE-clause

How can I achieve the desired result?

str.relation1.relation2.id means INNER JOIN
can you send your mapping?
i don`t know relation of your classes to help you

thanks for the answer. well its quite a complicated class web, so if this stepping through the properties means inner join, should I try using outer joins for each of those properties along the way instead of this simple a.b.c snytax? or is there an easier way then one outer join block for each step?

Okey, so that was the hint I needed, that way it works. So instead of


I now use


Not as beautiful as the first one, but has the advantage that it does what I want ;)