Hibernate version: 3.2

Name and version of the database you are using: MSSQL 2005

Hi.

I need to qualify a one-to-many relationship with some arbitrary SQL. Now the set element's where="<arbitrary SQL>" attribute suits this just fine. However, Hibernate puts my SQL at the beginning of the subselect. From an efficiency standpoint, my arbitrary SQL should come at the end. Is there a way to do this?

Thanks.