File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "HQL join query not executing" Watch "HQL join query not executing" New topic

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.
I agree. Here's the link:
subject: HQL join query not executing
jQuery in Action, 3rd edition