[hibernate-issues] [Hibernate-JIRA] Issue Comment Edited: (HHH-879) Enable joining the same association twice with Criteria

[guruofse (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-879?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=41829#action_41829 ] 

guruofse edited comment on HHH-879 at 3/23/11 7:15 AM:
-------------------------------------------------------

Message is removed as not in align.

      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

Many thanks in advance
  
> Enable joining the same association twice with Criteria
> -------------------------------------------------------
>
>                 Key: HHH-879
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-879
>             Project: Hibernate Core
>          Issue Type: Improvement
>          Components: core
>            Reporter: Vladimir Bayanov
>
> Make double joining the same association with Criteria.createCriteria possible. See: http://forum.hibernate.org/viewtopic.php?t=931249

-- 
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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira