title: JPA - left join 2 tables without association
body: <p>I have <strong>2 tables</strong>/entities with <strong>no association</strong>.
  I can go for <strong><em>cross joins</em></strong> in JPA</p>
  
  <pre><code>FROM A as a, B as b WHERE b.col1=a.col1
  </code></pre>
  
  <p><em><strong>How Can I perform a left-join?</em></strong></p>
  
  <p>I want all values from A and fill them up with B values where possible and leave NULL where there is no B. </p>
  
  <p><em>Does not work:</em></p>
  
  <pre><code>FROM A as a LEFT JOIN B as b WHERE b.col1=a.col1
  </code></pre>
  
  <blockquote>
    <p>Path expected for join!</p>
    
    <p>Invalid path: 'b.col1'</p>
  </blockquote>