I have the followind tables:

A one-to-many B with lazy = false. A has a collection of Bs named bs.

If I execute a find in A, the B collection is OK. But I need something like that:



Is that possible ? I looked at the documentation about this, with no success.

I'm using Hibernate 2.1.1 with Oracle 9.2

thanks a lot
Sergio

When execuing that, I got the following error:

Caused by: net.sf.hibernate.QueryException: expecting 'elements' or 'indices' after: surname [
from eg.A as a
where a.b.surname = :surname
order by a.name, a.bs.name
]

Use something like this pseudocode:

select A a
from a, B b
where b in elements(a.b)
and b.surname = ?

Doco section 10.8