Hello, I need some help to create criteria:

3 class ( tables):

Book (title, Author)
Author (name)
Dept (name, Author)

Book --> Author
Dept --> Author

public class Book {
....
public Author getAuthor();
}


public class Author {
....
public String getName();
}

public class Dept {
public String getName();
public Author getAuthor();

}

In our app, there is no mapping from Author to Dept.

List all books and their departments that wrote the books

Book Dept
-----------

How to use Criteria API to create such a query?

Thanks,
Dave

Do you even need the criteria API? http://jpa.ezhibernate.com/Javacode/learn.jsp?tutorial=09howtousethecriteriaapi

Why not just get the books, and then do the old book.getDepartments(), which will return to you all of the departments associated with the book?