R
- Return type for all joins except cross joinRC
- Return type for cross joinpublic interface HasJoins<R,RC>
Modifier and Type | Method and Description |
---|---|
<ENTITY> RC |
crossJoin(TableIdentifier<ENTITY> joinedTable)
Adds the provided
joinedTable to the collection of joined tables. |
<ENTITY> R |
innerJoinOn(HasComparableOperators<ENTITY,?> joinedField)
Adds the provided
joinedField to the collection of joined
column/tables. |
<ENTITY> R |
leftJoinOn(HasComparableOperators<ENTITY,?> joinedField)
Adds the provided
joinedField to the collection of joined
column/tables. |
<ENTITY> R |
rightJoinOn(HasComparableOperators<ENTITY,?> joinedField)
Adds the provided
joinedField to the collection of joined
column/tables. |
<ENTITY> R innerJoinOn(HasComparableOperators<ENTITY,?> joinedField)
joinedField
to the collection of joined
column/tables. Elements are joined from the table of the provided
joinedField
using an INNER JOIN whereby rows from two
tables are present only if there is a match between the joining columns.
Thus, rows that do not have matches in the joining columns will not be
present in the result.ENTITY
- entity typejoinedField
- to add to the current join builderjoinedField
is addedNullPointerException
- if the provided joinedField
is
null
<ENTITY> R leftJoinOn(HasComparableOperators<ENTITY,?> joinedField)
joinedField
to the collection of joined
column/tables. Elements are joined from the table of the provided
joinedField
using an LEFT JOIN whereby rows from two
tables are present either if there is a match between the joining columns
or for each row from previously existing table(s).
Unmatched rows will have entities from the table in the given
joinedField
set to null
ENTITY
- entity typejoinedField
- to add to the current join builderjoinedField
is addedNullPointerException
- if the provided joinedField
is
null
<ENTITY> R rightJoinOn(HasComparableOperators<ENTITY,?> joinedField)
joinedField
to the collection of joined
column/tables. Elements are joined from the table of the provided
joinedField
using an RIGHT JOIN whereby rows from two
tables are present either if there is a match between the joining columns
or for each row from the table for the provided joinedField
.
Unmatched rows will have entities from the table in the given
joinedField
set to null
ENTITY
- entity typejoinedField
- to add to the current join builderjoinedField
is addedNullPointerException
- if the provided joinedField
is
null
<ENTITY> RC crossJoin(TableIdentifier<ENTITY> joinedTable)
joinedTable
to the collection of joined tables.
Elements are joined from the table of the provided joinedTable
using an CROSS JOIN whereby all combination of rows using all
tables(s) are produced.ENTITY
- entity typejoinedTable
- to add to the current join builderjoinedField
is addedNullPointerException
- if the provided joinedField
is
null
Copyright © 2018 Speedment, Inc.. All rights reserved.