title: Join 3 tables in Spring Jpa Data
body: <p>I've been struggling lately to join 3 tables with spring data jpa. I have 3 entities, <code>Series</code>, <code>Dossier</code> and <code>Item</code>. <code>Series</code> has many <code>Dossiers</code>, and <code>Dossier</code> has many <code>Items</code> (Relationships). I do something like <code>Series.join(Dossier_.series).join(Dossier_.items)</code> and I end up with a Join set. I want to make the following query:</p>
  
  <pre><code>Select Items from Series,Dossier,Item 
  Where Series.Id=Dossier.seriesId 
  and Dossier.id=Item.dossierId 
  and series.projectId = :param
  </code></pre>
  
  <p>I can't express this statement with Spring Specifications and criteria api....Please shed some light</p>