title: Hibernate Criteria join two tables
body: <p>I've 3 table:
  PERSON: ID, NAME, SURNAME
  TEAM: ID, NAME, PERSON, ROLE
  ROLE: ID, POSITION
  where TEAM could have a list of PERSON</p>
  
  <p>I need to create a query, with Hibernate Criteria, like this:
  select * from PERSON p, TEAM t
      where t.ROLE = "myRole" and t.PERSON = p.id</p>
  
  <p>I want to get the list of PERSON in TEAM with a given ROLE.
  Can you help me? Thanks</p>