title: Hibernate : getting multiple table columns results from multiple tables
body: <p>I am using hibernate 4 and Spring 3.</p>
  
  <p>I have 5 tables and each table is mapped with 1 entity class.Now if I have to select columns from 1 table than i will do below :</p>
  
  <pre><code>String hql = "from Employee E";
  Query query = session.createQuery(hql);
  List results = query.list();
  </code></pre>
  
  <p>This value in this result will be of type EmployeeEntity.</p>
  
  <p>Or I can use Criteria as well.</p>
  
  <p>Now my requirnment is that I have to get the result from all 5 tables.1-2 columns from each table.</p>
  
  <p>Earlier it was one 1 table so i was getting one entity , now I am getting results from 5 tables so how to map it in entity.</p>
  
  <p>List results1 = query.list(); // considering select and getting 6 columns in results with diffenent tables.</p>
  
  <p>Now how to iterate this result1.</p>
  
  <p>I hope you got my question.</p>