title: HQL Hibernate INNER JOIN
body: <p>How can I write this SQL query in Hibernate? I would like to use Hibernate to create queries, not create the database.</p>
  
  <pre><code>SELECT * FROM Employee e INNER JOIN Team t ON e.Id_team=t.Id_team
  </code></pre>
  
  <p>I created entity classes in SQLServer2008, </p>
  
  <pre><code>@Entity
  @Table(name="EMPLOYEE")
  public class Employee
  {
      @Id @GeneratedValue
      @Column(name="ID_EMPLOYEE")
      private int id_employee;
      @Column(name="SURNAME")
      private String surname;
      @Column(name="FIRSTNAME")
      private String firstname;
      @Column(name="ID_PROFESSION")
      private int id_profession;
      @Column(name="ID_BOSS")
      private int id_boss;
      @Column(name="HIRED_DATE")
      private Date hired;
      @Column(name="SALARY")
      private double salary;
      @Column(name="SALARY_ADD")
      private double salary_add;
      @Column(name="ID_TEAM")
      private int id_team;
      //setters and getters
  }
  
  @Entity
  @Table(name="TEAM")
  public class Team
  {
      @Id @GeneratedValue
      @Column(name="ID_TEAM")
      private int id_team;
      @Column(name="TEAMNAME")
      private String teamname;
      @Column(name="ADDRESS")
      private String address;
      //setters and getters
  }
  </code></pre>
  
  <p>I tried to build working select query in many ways but it still doesn't work.</p>
  
  <pre><code>SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
  Session session = sessionFactory.openSession();                 
  session.beginTransaction();
  String select = "FROM Employee e INNER JOIN Team t ON e.Id_team=t.Id_team";
  Query query = session.createQuery(select);
  List elist = query.list();
  session.getTransaction().commit();
  session.close();    
  </code></pre>
  
  <p>Maybe something is wrong with entities?</p>