This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes HQL join query not executing Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "HQL join query not executing" Watch "HQL join query not executing" New topic
Author

HQL join query not executing

saravanan sambandam
Ranch Hand

Joined: Aug 30, 2010
Posts: 42
I have 3 tables

user_master : contain with user_id, user_name
group_master : contain with group_id, group_name
user_group : contain with user_group_id, group_id, user_id

SQL statment : select a.user_group_id, b.group_id, b.group_name from user_group a left outer join group_master b on b.group_id=a.group_id;
but when i am using HQL is not execute what i did the mistake? please let me know




This query is not executing please help me where i did the mistake.
Thanks
Saran.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: HQL join query not executing
 
Similar Threads
Convert SQL to Criteria please
@ManyToOne & @JoinColumn
Help me for Joinin two tables.
How to create .hbm.xml file for this table?
Help with HQL Insert and Joins using Hibernate 3 / JPA