We're updating the issue view to help you get more done. 

Explicit joins on unrelated classes

Description

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

Environment

Any

Status

Assignee

Steve Ebersole

Reporter

David Lloyd

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

antlr-rework

Priority

Major