title: Ormlite inner join on three tables
body: <p>i want to create an inner join on three tables like this one for example:</p>
  
  <pre><code>SELECT C.Description, D.ItemDescription
    FROM OrderDetailStatement AS D 
   INNER JOIN OrderHeaderStatement AS H 
      ON H.OrderHeaderStatementRefID = D.OrderHeaderStatementRefID 
   INNER JOIN customers AS C 
      ON H.CustomerRefID = C.CustomerRefID
   WHERE (D.MixedValue &gt; 1000)
  </code></pre>
  
  <p>but i'm a little bit confused, could you please provide me a walkthrough?</p>
  
  <p>thanks in advance</p>