Forums Register Login

HQL query hibernate

+Pie Number of slices to send: Send
SELECT c from (SELECT Count(*) as abc , a1 as id FROM Auction a1,MaterialList ml where a1.material_list.materialListId=ml.materialListId and ml.materialListStatus.materialListStatusId=2 GROUP BY a1.client.clientId ) as Auction as a.id right join Client c On a group by c.clientId

Hi,

I m new to hibernate

I m using subquery in from clause n wanna apply right join to the result of subquery with client table

Can anybody tell me the exact syntax for this


Please Help
Thanks
Raman
Wink, wink, nudge, nudge, say no more, it's a tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 1208 times.
Similar Threads
Joins in Hibernate
SubQuery in Hibernate
SQL to HQL
Correlated Subquery in Hibernate
how to use variable with oracle like
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 17:39:10.