Hi;

Am priya..dot net developer but my new project happened to be in hibernate java..hibernate seems to be interesting but kinda difficult to get used to it..i need Ur help..

i have a query joining two different tables without any mapping association.i really wonder how i can put the query in using hibernate criteria projections..

My query :
select top 1 e.code from
(select wcp.cz_code as code ,SUM(dl.net_amount_amount) as Total_amount from detail dl
inner join
paycode wcp on (dl.long_or_short_code = wcp.name )
where dl.header_id =8 and wcp.tree_position like 'long%'
group by wcp.cz_code )as E

order by E.Total_amount desc

please help me with this.

Thanks,
Priya