title: joining two tables with differnt join column names
body: <p>I have two tables A -> B with many-to-one mapping/associations.</p>
  
  <p>Table B's primary key is foreign key in table A.</p>
  
  <p>The problem is column names in both tables are different. let's say B has primary  key column "typeNumId" which is foreign key in table A as "type". How can I join both tables on this column? how can I specify mapping to indicate that tables have to join on "typeNumId" and "type" which is essentially same.</p>
  
  <p>especially is this possible through hibernate config ( hbm files) ?</p>
  
  <p>something like</p>
  
  <pre><code>&lt;many-to-one name="Type" class="com.domain.ProcedureType" update="false" insert="false" fetch="join" lazy="false"&gt;
      &lt;column name="? &lt;this is in questions? &gt;" not-null="true" /&gt;
  &lt;/many-to-one&gt;
  </code></pre>