Internal Website Search

How write a query in JPA2 with LEFT JOIN on INNER JOIN? join action_profile ap1 on ap1.id_action=a.id inner join profile p1 on ap1.id_profile=p1.id and p1.name='?' left join action_profile ap2 on ap2.id_action=a.id inner join profile p2 on ap2.id_profile

> select doi from Doi doi left join fetch doi.metadata metadata left join fetch metadata.titles titles left join fetch metadata.creators creators left join fetch metadata.descriptions descriptions left join fetch metadata.publishers publishers left join fetch metadata

> , Join" title="Interface in javax.persistence.criteria">Join<Z,E> , The CollectionJoin interface is the type of the result of joining

; , Join" title="Interface in javax.persistence.criteria">Join<Z,V> , The MapJoin interface is the type of the result of joining to a collection

; , Join" title="Interface in javax.persistence.criteria">Join<Z,E> , The PluralJoin interface defines functionality that is common to joins

.criteria">CollectionJoin , Join" title="Interface in javax.persistence.criteria">Join , Serves as a factory for Joins

"> Create a fetch join to the specified attribute using an inner join. Create a fetch join to the specified attribute using an inner join. Parameters

/jpa/query/jpql/from#inner_join">equivalent JOIN query. Entity Type ExpressionsJoin">Join and Join's descendants). Path ExpressionsJoin">Join interfaces (which are subinterfaces of

are indexable (extremely fast JOIN queries). Map keys and values are indexable.join_fetch">FETCH JOIN.FROM (including join">INNER JOIN

_join">Join variables (bound by an attribute of a preceding variable in the FROM clause) are represented by the Join subinterface and its descendant interfaces: Join|PluralJoin|CollectionJoin|SetJoin