I've added a maven project that could demonstrates the issue.

To run it, just specify the correct database connection info in the persistence.xml under /src/test/resources.

Please note that, the hibernate generated sql put the line "department department1_ " prior to the inner join:

select
...
from
Employee employee0_,
Department department1_
inner join
....
where
...

But actually the correct sql should be like:

select
...
from
Employee employee0_
inner join
Title title2_
on employee0_.title_id=title2_.id,
Department department1_
where
...