Still trying to get a handle on the joining. I would like to eventually use left and right joins but for now trying this query below and comparing it with one where I use paths day.meetingDays.meeting.schedule.scheduleId=1.

This is my join query: (The examples in the documentation do not cover this case)

Query q = session.createQuery("select day " +
" from Day as day inner join" +
" MeetingDays.day as md inner join" +
" Meeting.meetingId as m join" +
" Schedule.scheduleId as schedule" +
" where schedule.scheduleId=1 ");

I keep getting the following error:

net.sf.hibernate.QueryException: undefined alias: Meeting

Relationships are as follows:

Day to MeetingDays is a one to many from Day to MeetingDays with inverse set to true.
Meeting to MeetingDays is a one-to-many with inverse=true.
Schdedule to Meeting is a one-to-many with inverse=true.

when I add the package names to the classes my.package.name.MeetingDays, I get an undefined alias issue as well.

Thanks

I don't think it makes sense to join a mapped object with an attribute !
As I don't think it makes sense to map a table with a column in SQL.

Never played whith join, so take it 'as is' but your query would probably much look like