Regarding Query

Hi

I am using three tables USER,ROLE and USERROLELINK.
USER and ROLE table is not directly linked , it has been linked with USERROLELINK table through linkid, it is been mapped through Hibernate.

I cant able to get the HQL for this, can you give me the HQL for userlist based on the role selection.

Hi vinoth raj welcome to Javaranch

,

Please CarefullyChooseOneForum.
This question is by no means related to servlets
one of the moderators will move it to its proper place.
And also UseAMeaningfulSubjectLine.
"Regarding Query " is is less descriptive.

And take some time to read the ask good question link below.
[ August 07, 2008: Message edited by: Amit Ghorpade ]

Please do not cross-post the same question in multiple forums. It wastes people's time when multiple redundant conversations take place. Please read this for more information.