title: Join without association in HQL
body: <p>Lets say I have two tables(A, B) like:</p>
  
  <pre><code>A {id, a, c}
  B {id, b, c}
  </code></pre>
  
  <p>I have also their entities. I want to write an HQL so that the result set will be like (where A.c = B.c):</p>
  
  <pre><code>(a1, b1, c1)
  (a2, b2, c2)
  (a3, b3, c3)
  ...
  </code></pre>
  
  <p>Since <code>on</code> clauses are not supported by hibernate I am stuck and I don't know how to write the query.</p>