[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-16) Explicit joins on unrelated classes

[Joakim Clivemo (JIRA)]

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

Joakim Clivemo commented on HHH-16:
-----------------------------------

Me and my compandy desperatly need at least the basic functionality to create outer joins on unrelated classes by specifying the ON clause!
Adding criterias by "WITH" or "AND" to the join is pure bonus.

Any progress or fixes in sight to solve this?


> Explicit joins on unrelated classes
> -----------------------------------
>
>                 Key: HHH-16
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-16
>             Project: Hibernate Core
>          Issue Type: New Feature
>          Components: core
>    Affects Versions: antlr-rework
>         Environment: Any
>            Reporter: David Lloyd
>            Assignee: Steve Ebersole
>             Fix For: antlr-rework
>
>
> It would be nice to be able to do explicit joins on unrelated classes with HQL:
> (hope this renders correctly)
>           select empl, phone
>             from org.example.Employee empl
>  left outer join org.example.PhoneBook phone
>               on phone.lastName = empl.lastName
>              and phone.firstName = empl.firstName
>            where empl.salaryGrade > 10
> Note that this would also implicity solve HB-1089 because you could list join criteria that match what Hibernate would have chosen anyway (i.e., list a many-to-one relationship as a criteria explicitly).
> Syntactically this could be disambiguated from the existing join syntax because the token after "join" is a class name rather than a property name.

-- 
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