Hi everyone,
I'm facing a problem with my hbm mapping and an help would be highly appreciated.

This is the scenario:
Table_A: id, initial_date, limit_date, description
Table_B: id, event_date, id_table_A (fk)

The query I would like to perform is:

select *
from Table_B b
inner join Table_A a on
b.id_table_A = a.id and
b.event_date >= a.initial_date and
b.event_date <= a.limit_date
where (....)

How can I realize a mapping to get the join translated by Hibernate exactly in this way? I don't want to move the condition in 'where' clause, because performance are really bad.

Thanks for any help you may provide.