title: Join two un-related tables using JPA EntityManager
body: <p>I need to join two JPA entities on a property when there is no FK/PK relation between the two.
  I am using Hibernate and can use HQL query like this</p>
  
  <pre><code> select foo, bar from FooEntity as foo, BarEntity as bar
   where  foo.someothercol = 'foo' and foo.somecol = bar.somecol
  </code></pre>
  
  <p>However, I want to avoid dependency on Hibernate and use EntityManager instead.
  Please help.</p>