Can someone give me a brief explanation about join in hql?
I can't understand it after reading the documentation.
All I can get is join is used to give alias for property on an entity.
I can't understand what's the different between join, left join, right join and full join.

And, is it similar to join in sql?
All I know about join in sql is that it is used to join tables so we can select from those tables.

Read that chapter:

http://www.theserverside.com/books/revi ... Review.jsp