About LEFT OUTER JOIN

1-10 of 200Refresh
Manual
126

FROM clause (JPQL / Criteria API)

function as implicit INNER JOIN variables. LEFT [OUTER] JOIN To understand the purpose of OUTER JOIN ... c, p.name FROM Country c LEFT OUTER JOIN c.capital p The OUTER keyword is optional (LEFT OUTER JOIN is equivalent to LEFT JOIN). When using OUTER JOIN, if a specific outer variable does not
JDO Doc
58

Join.outer

Annotation Element javax.jdo.annotations.Join String outer Whether to use an outer join. Returns: whether to use an outer join Default value: "" Since: JDO 2.1
JPA Doc
52

JoinType.LEFT

Enum Constant javax.persistence.criteria.JoinType LEFT Left outer join. Since: JPA 2.0
Forum
45

Possible issue for JPQL "LEFT [OUTER] JOIN"

Possible issue for JPQL "LEFT [OUTER] JOIN" is doing "[INNER] JOIN".   Thanks. Thank ... work with the following JPQL queries string:     - "SELECT a,b FROM A a LEFT OUTER JOIN a.listB b ... ] [A4, null]??? NULL is only for single-valued field.     - "SELECT a,b FROM A a LEFT OUTER JOIN a.listB
Forum
44

LEFT (OUTER) JOIN problem when mappedBy is defined

this query: "SELECT i FROM Invoice i LEFT OUTER JOIN i.itemList items" But this query never returns invoices without items! Only invoices with items. When I remove mappedBy from @OneToMany annotation, LEFT ... Invoice i LEFT OUTER JOIN i.itemList items"); List resultList = query.getResultList
Forum
37

Query in JPA2 with LEFT JOIN on INNER JOIN

_0_ from ACTION action0_ left outer join ACTION_PROFILE actionprof1_ on action0_.ID=actionprof1_.ID_ACTION left outer join ACTION_PROFILE actionprof2_ on action0_.ID=actionprof2_.ID_ACTION left outer join ACTION_PROFILE actionprof3_ on action0_.ID
Result
35

ObjectDB Object Database Features [2018-01-27]

(including INNER JOIN, LEFT OUTER JOIN and JOIN FETCH). WHERE (with both JPQL and JDOQL expressions ... elements are indexable (extremely fast JOIN queries). Map keys and values are indexable. Nested paths ... query FETCH JOIN. Configurable JDO fetch groups. Ease of Use and Learning ObjectDB is very simple
Result
35

ObjectDB Object Database Features [2018-10-27]

(including INNER JOIN, LEFT OUTER JOIN and JOIN FETCH). WHERE (with both JPQL and JDOQL expressions ... elements are indexable (extremely fast JOIN queries). Map keys and values are indexable. Nested paths ... query FETCH JOIN. Configurable JDO fetch groups. Ease of Use and Learning ObjectDB is very simple
Result
35

ObjectDB Object Database Features

(first, max) - for paging. Query Structure SELECT (including NEW). FROM (including INNER JOIN, LEFT OUTER JOIN and JOIN FETCH). WHERE (with both JPQL and JDOQL expressions). GROUP BY (including HAVING ... (extremely fast JOIN queries). Map keys and values are indexable. Nested paths inside embedded objects
JDO Doc
27

javax.jdo.annotations.Join

. Returns: whether the join column(s) is(are) indexed Default value: "" Since: JDO 2.1 String outer Whether to use an outer join. Whether to use an outer join. Returns: whether to use an outer join Default ... javax.jdo.annotations Annotation Join Target: Classes and fields (including property get methods