Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: NHibernate 1.2 beta 3

Name and version of the database you are using: MS SQL Server 2000

Hi,

Is it possible to use a derived table join to filter results in a query rather than have to use a WHERE IN (...) clause with a sub-query?

I need to return the max ID grouped by a foreign key and then only return those objects join fetched to others for my query.

There is a 54% : 46% performance ratio between a WHERE IN subquery compared to a joined derived table with the data I require.

Any help will be greatly appreciated

I am wondering whether this is possible too, sure we can do it with pure SQL, but if it's possible with HQL, then that would be great. I am experiencing performance problem with subqueries(some db has real problem to optimize some subqueries, especially IN), derived table in HQL will greatly enhance the performance.