About INNER JOIN

manual

FROM clause (JPQL / Criteria API)

Explains how to use the FROM clause and JOIN expressions in a JPA/JPQL query.... topics: Range Variables [INNER] JOIN LEFT [OUTER] JOIN [LEFT [OUTER] | INNER] JOIN ...

 
forum_thread

Query in JPA2 with LEFT JOIN on INNER JOIN

select a.description, a.id, p1.description, p2.description,p3.description from action a left 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=p2.id  and p2.name='?' where a.id =?;   Thanks   ... How write a query in JPA2 with LEFT JOIN on INNER JOIN? SELECT a . description , a . id , p1 . ...

 
api-jpa

javax.persistence.criteria.Join

A join to an entity, embeddable, or basic type.(Interface of JPA)

 
api-jpa

javax.persistence.criteria.MapJoin

The MapJoin interface is the type of the result of joining to a collection over an association or element collection that has been specified as a java.util.Map.(Interface of JPA)

 
api-jpa

javax.persistence.criteria.CollectionJoin

The CollectionJoin interface is the type of the result of joining to a collection over an association or element collection that has been specified as a java.util.Collection.(Interface of JPA)

 
api-jpa

javax.persistence.criteria.SetJoin

The SetJoin interface is the type of the result of joining to a collection over an association or element collection that has been specified as a java.util.Set.(Interface of JPA)

 
api-jpa

javax.persistence.criteria.ListJoin

The ListJoin interface is the type of the result of joining to a collection over an association or element collection that has been specified as a java.util.List.(Interface of JPA)

 
api-jpa

javax.persistence.criteria.PluralJoin

The PluralJoin interface defines functionality that is common to joins to all collection types.(Interface of JPA)

 
api-jpa

javax.persistence.criteria.From

Represents a bound type, usually an entity that appears in the from clause, but may also be an embeddable belonging to an entity in the from clause.(Interface of JPA)

 
api-jpa

javax.persistence.criteria.Root

A root type in the from clause.(Interface of JPA)