title: How to add left join multiple tables in hibernate based on 4th table attributes as join condition
body: <p>I have 4 tables</p>
  
  <p>A,B,C,D</p>
  
  <p>I want to perform the following SQL query:</p>
  
  <pre><code>select *
  from A
    left join B
      on a.d = b.d
    left Join C
      on c.d = b.d
  </code></pre>
  
  <p>Please suggest how can i achieve it I have mapping in A/B/C for D</p>
  
  <pre><code>@Override
  @ManyToOne(fetch = FetchType.LAZY)
  @JoinColumn(name = "ID", nullable = false)
  public D getDObj() {
     return DObj;
  }
  </code></pre>
  
  <p>Please suggest.</p>