Learned Today: Joining with Hibernate

Hibernate (and NHibernate) is able to do a lot of different kind of joins. Unfortunately it can not do outer joins on properties that are not mapped as associations. My goal was to get the result of the following SQL-query with an outer join: SELECT e.Name, d.Status, count(*) FROM event eLEFT OUTER JOIN delivery d on e.Id = d.EventIdGROUP BY e.Name, d.StatusI hoped to realize the above query