I am having difficulties creating a HQL query to retrieve a Parent object and fetching only one child from its set of children via an outer join. The join condition is to retieve the child given its database id.

I have noticed in the documentation that you can add join conditions via 'with' but it rejects asking for a filter.

Thank you for your time,
James.

Why don't you select the child object by its db id and have hibernate set its parent property? (in case it is bidirectional)