I have the following tables
Table : A
id name
Table : B
id job
Table AB
A_id B_id

A to B is Many to One

B to A is One to many
I want to get name from Table A
How will I write a Hibernate criteria for something like this

select s.name from
(select * from a,b,ab where
b.job="NN"

and a.id=ab.a_id and
b.id=ab.b_id
)s

Any help is appreciated ..
Thanks