can u suggest me which is the best tutorial for hql joins

Hi, you're opening many threads for very trivial questions, you could answer all of them just reading any book on Hibernate.
Please I really wish I had the time to help all beginners, but that's not the case, so please start reading the quickstart:
http://docs.jboss.org/hibernate/core/3.6/quickstart/en-US/html_single/

And follow with any tutorial, and then read the reference documentation:
http://docs.jboss.org/hibernate/core/3.6/reference/en-US/html_single/

And possibly try out some of the excellent working examples provided by Seam:
http://www.seamframework.org/Seam2/Downloads