I have a situation here where I need to create a multi join query using hibernate criteria api... the sql format of the query is:

SELECT p.name, pp.name
FROM team t,player p,position pp
where p.teamId = t.teamId
and t.leagueId = 1
and p.positionId = pp.positionId
in the above query t.leagueId is a variable which I will be passing while calling this .... can some help me in writing the hibernate criteria query for this...

Thanks in advance.