title: Could I use LLBL Gen to JOIN columns between tables which don't have a relationship of primary-foreign keys?
body: <p>I have the following DB structure</p>
  
  <p><em>Table1( ID1,Col1,Col2)  and Table1( ID2,Col3,Col4)</em></p>
  
  <p>Table1 and Table2 are separate table  and don't have any relationships between them.</p>
  
  <p>and I would like to achieve the following result</p>
  
  <p><strong>SELECT *
  FROM
      Table1  JOIN Table2 ON Table1.Col1= Table2.Col3</strong></p>
  
  <p>How could I achieve that using LLBL Gen Adapter.</p>
  
  <p>Thanks.</p>