[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-879?page=co... ] guruofse edited comment on HHH-879 at 3/23/11 2:17 AM: ------------------------------------------------------- Hi Aryan, I am newbie in Hibernate detached criteria query. During googling of my problem I come across to your post, I have just slight different problem then Scott Haynie. Could you please tell me what should be the Detached criteria code to achieve query like below? select a.col1, b.col1, count(c.col1) from TableA a right outer join (TableB b, TableC c) on a.ID=b.A_ID and a.ID=c.A_ID where b.col='oneval' and c.col='anotherval' group by a.col1 Many thanks in advance was (Author: guruofse): Hi Aryan, I am newbie in Hibernate detached criteria query. During googling of my problem I come across to your post, I have just slight different problem then Scott Haynie. Could you please tell me what should be the Detached criteria code to achieve query like below? select a.col1, b.col1, count(c.col1) from TableA a right outer join (TableB b, TableC c) on a.ID=b.A_ID and a.ID=c.A_ID where b.col='oneval' and c.col='anotherval' group by a.col1 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira