Hi,

i have an issue to execute the HQL query. the scenario is like this.

select * from ( select x.abc, y1.def, z.ghi from X x left outer join (select id from X where date=?) x1 on x1.id = x.id left outer join (select id, def from Y where date=?) y1 on y1.id = x.id inner join Z z on x.id = z.id;

please let me know executable query using HQL.

Thanks in Advance.

warm wishes
Purushotham

Please refer this. It would be helpful.

http://docs.jboss.org/hibernate/stable/ ... l-examples