Hibernate version:
Hibernate 3

Name and version of the database you are using:
MySQL 5


I would like to generate complex outer joins with HQL.

For example:

(you must assume the usual map files and pojos)

two tables like these:

questions

• id (PK)
  
• question

answers

• id (PK)
  
• idQuestion (FK on questions)
  
• idPerson (FK on People)
  
• answer

With SQL I can ask for:

With it, I can get ALL the questions along with the existing answers of person with id 666.

With HQL I can do something like this:


BUT, how I could intro the person restriction?????
This doesn't work

Because it only gives me the questions where exists an answer.

Any hint???

I found it!

the HQL keyword to do it is with


It's only curiosity but any Hibernate developper could tell me why they choose with instead of on like in SQL.