title: JPA merging two or more tables into another table
body: <p>Is it possible to take some columns from some tables(entities) and store them to another table's columns with JPA, Hibernate?</p>
  
  <p>For example;<br>
  Table1 : id, name,  surname, ...<br>
  Table2 : id, school, city, ...   </p>
  
  <p>Table3: unqId, name, surname, school, city</p>
  
  <p>Select from Table1 and Table2 and insert into Table3.</p>
  
  <p>Or alternatively, Select result as Table3 entity from Table1 and Table2.</p>
  
  <p>Thanks.</p>