title: Hql, How to write join query between tables that has one to many relationship?
body: <p>I have <code>2</code> tables. <code>1st</code> one have <code>oneToMany</code> relationship with <code>2nd</code>.</p>
  
  <p>Class Author</p>
  
  <pre><code>@Entity
  @Table(name = "Author")
  Public class Author{
  
      @Id
      @Column(name = "AuthorId")
      private int autherId;
  
      @Column(name = "AuthorName")
      private String authorName;
  
      @OneToMany
      @JoinColumn(name="AuthorId",referencedColumnName="AuthorId")
      List&lt;Book&gt; Books;
  
      //getter and setter
  }
  </code></pre>
  
  <p>Class Book</p>
  
  <pre><code>@Entity
  @Table(name = "Book")
  Public class Book{
  
      @Id
      @Column(name = "BookId")
      private int bookId;
  
      @Column(name = "BookName")
      private String bookName;
  
      @Column(name = "AuthorId")
      private int authorId;
  
      //getter and setter
  }
  </code></pre>
  
  <p>How can I write a <code>Hql</code> query so that I will get all author's and there books , with a condition that book name should starts with <code>hello</code></p>
  
  <p>I know using a query like this,</p>
  
  <pre><code>  from Author;
  </code></pre>
  
  <p>I can fetch all author's and there books,but how to give condition on book?</p>