Exception in thread "main" org.hibernate.hql.ast.QuerySyntaxException: unexpected token: on near line 1, column 84 [select b from de.taf.easygo.modules.timetable.hafas.Bahnhof as b join BfKoord as k on b.nummer = k.bahnhof_nummer where (k.x >= 10.993004838908002 and k.x <= 11.006995161091998 and k.y >= 49.9955035971223 and k.y <= 50.0044964028777) order by b.name]

Could anybody pls tell me what exactly causes this exception? =(

Many thanx!

The exception is caused by the
part. Hibernate knows from the mapping which columns to join - so you must not add this to your query. This is also what the error message says:

Thank you very much. I needed to join b.koord for it to work. But one question remains. Do I _always_ need a forward association, (cos I created it for that)? Is it possible to join BfKoord on BfKoord.bahnhof, the other direction?