[nhusers] Re: Can HQL join subqueries?

[Koushik Paul]

There was only one column in the IN clause, when I have to match with
multiple column, in SQL I use join with ON clause " ON a.x=b.x and a.y=b.y)

Is it possible in HQL also ?

Can someone please help me turn the following sql statement into an
nhibernate HQL query?
select * from mmt_storage_product m inner join
(select storage_ID, max(asofdatetime) as asofdatetime from
mmt_storage_product s group by storage_ID ) s
on m.asofdatetime = s.asofdatetime
This is my attempt so far: The naming is a bit different for my HQL
because of changes in class names and paramters.
session.CreateQuery("from StorageProduct m inner join (select
storageID, max(asOfDateTime) as asOfDateTime from StorageProduct s) on
m.asOfDateTime = s.asOfDateTime")
.List<BLL.Storage.StorageProduct>();
Thanks so much.