title: QueryDSL Join multiple tables and subqueries
body: <p>I am new to queryDSL. My application have a complex search page with more number of search fields. Can anyone help me in forming a QueryDSL query for the below one:</p>
  
  <pre><code>select pt.pID
       , ct.name 
    from PARENT_TABLE pt 
    left 
    join CHILD_TABLE ct 
      on pt.pID = ct.cID 
   where pt.pID = '1000'
  </code></pre>
  
  <p>By using Predicates any() method I tried to join but with that i am unable to fetch the actual data. Without configuring entity manager is it possible to solve this?</p>
  
  <p>Please let me know if more info needed.
  Thanks in advance</p>