Hibernate version: 2.1

Name and version of the database you are using: MySQL 4.1


I have a one to many relationship between Asset and AssetState. The purpose of the one to many relationship is to keep a history of the Asset's state.

When I do:
from asset as a
where a.assetId = ?

I get:
The particular asset with a set of all related AssetStates.

When we want to view only the current state I would like to run a query that will only contain a subset of the related AssetState objects - namely the most current AssetState object.

pseudo-query:
find asset
where the assetID = aid0001

setAssetStates
where assetState.stateDate = max(stateDate for this asset's states)

Is this query possible and if so how?

Thank you
Bryon