title: How do I do with HQL, many to many?
body: <p><img src="https://i.stack.imgur.com/l6hAt.png" alt="enter image description here"></p>
  
  <p>Here is my database structure. Relation many to many. I want to make a selection of authors who have written the same book. With SQL, I did. How do I do with HQL?</p>
  
  <pre><code>   Query query = session.createSQLQuery("SELECT FirstName, LastName FROM authors, books, author_book as ab WHERE ab.authorID=authors.authorID AND ab.bookID = books.bookID AND ab.bookID = :id");
     query.setInteger("id", 1);
     List list = query.list();
     Iterator&lt;Object[]&gt; iter = list.iterator();
     while (iter.hasNext()) {
         Object[] obj = iter.next();
         System.out.println(obj[0] + " " + obj[1]);
      }
  </code></pre>