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
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