title: ORMLite: How to join two tables without foreign key
body: <p>I have to join two independent tables in <code>sqlite</code>. They don't have any foreign key relationship.</p>
  
  <p>Example: </p>
  
  <ul>
  <li>Table A has a field <code>name</code></li>
  <li>Table B has a field <code>primaryName</code></li>
  </ul>
  
  <p>I want to do something like</p>
  
  <pre><code>select A.* from A inner join B on A.name = B.primaryName
      where A.id = 10 and B.address is null
  </code></pre>
  
  <p><code>ORMLite</code> enforces foreign key, is there a way to do this in <code>ORMLite</code>?</p>