- All Superinterfaces:
Attachable
,AttachableQueryPart
,FieldLike
,FieldOrRowOrSelect
,Fields
,Flow.Publisher<R>
,Iterable<R>
,Publisher<R>
,org.reactivestreams.Publisher<R>
,Query
,QueryPart
,ResultQuery<R>
,Select<R>
,SelectConnectByStep<R>
,SelectCorrelatedSubqueryStep<R>
,SelectFinalStep<R>
,SelectForStep<R>
,SelectForUpdateStep<R>
,SelectGroupByStep<R>
,SelectHavingStep<R>
,SelectLimitStep<R>
,SelectOptionStep<R>
,SelectOrderByStep<R>
,SelectQualifyStep<R>
,SelectUnionStep<R>
,SelectWhereStep<R>
,SelectWindowStep<R>
,Serializable
,Statement
,TableLike<R>
- All Known Subinterfaces:
SelectOnConditionStep<R>
,SelectOptionalOnStep<R>
Select
's DSL API when selecting generic
Record
types.
Example:
-- get all authors' first and last names, and the number
-- of books they've written in German, if they have written
-- more than five books in German in the last three years
-- (from 2011), and sort those authors by last names
-- limiting results to the second and third row
SELECT T_AUTHOR.FIRST_NAME, T_AUTHOR.LAST_NAME, COUNT(*)
FROM T_AUTHOR
JOIN T_BOOK ON T_AUTHOR.ID = T_BOOK.AUTHOR_ID
WHERE T_BOOK.LANGUAGE = 'DE'
AND T_BOOK.PUBLISHED > '2008-01-01'
GROUP BY T_AUTHOR.FIRST_NAME, T_AUTHOR.LAST_NAME
HAVING COUNT(*) > 5
ORDER BY T_AUTHOR.LAST_NAME ASC NULLS FIRST
LIMIT 2
OFFSET 1
FOR UPDATE
OF FIRST_NAME, LAST_NAME
NO WAIT
Its equivalent in jOOQ
create.select(TAuthor.FIRST_NAME, TAuthor.LAST_NAME, create.count())
.from(T_AUTHOR)
.join(T_BOOK).on(TBook.AUTHOR_ID.equal(TAuthor.ID))
.where(TBook.LANGUAGE.equal("DE"))
.and(TBook.PUBLISHED.greaterThan(parseDate('2008-01-01')))
.groupBy(TAuthor.FIRST_NAME, TAuthor.LAST_NAME)
.having(create.count().greaterThan(5))
.orderBy(TAuthor.LAST_NAME.asc().nullsFirst())
.limit(2)
.offset(1)
.forUpdate()
.of(TAuthor.FIRST_NAME, TAuthor.LAST_NAME)
.noWait();
Refer to the manual for more details
Referencing XYZ*Step
types directly from client code
It is usually not recommended to reference any XYZ*Step
types
directly from client code, or assign them to local variables. When writing
dynamic SQL, creating a statement's components dynamically, and passing them
to the DSL API statically is usually a better choice. See the manual's
section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.
Drawbacks of referencing the XYZ*Step
types directly:
- They're operating on mutable implementations (as of jOOQ 3.x)
- They're less composable and not easy to get right when dynamic SQL gets complex
- They're less readable
- They might have binary incompatible changes between minor releases
- Author:
- Lukas Eder
-
Method Summary
Modifier and TypeMethodDescription@NotNull SelectJoinStep<R>
crossApply
(String sql) CROSS APPLY
a table to this table.@NotNull SelectJoinStep<R>
crossApply
(String sql, Object... bindings) CROSS APPLY
a table to this table.@NotNull SelectJoinStep<R>
crossApply
(String sql, QueryPart... parts) CROSS APPLY
a table to this table.@NotNull SelectJoinStep<R>
crossApply
(Name name) CROSS APPLY
a table to this table.@NotNull SelectJoinStep<R>
crossApply
(SQL sql) CROSS APPLY
a table to this table.@NotNull SelectJoinStep<R>
crossApply
(TableLike<?> table) CROSS APPLY
a table to this table.@NotNull SelectJoinStep<R>
Convenience method toCROSS JOIN
a table to the last table added to theFROM
clause usingTable.crossJoin(String)
@NotNull SelectJoinStep<R>
Convenience method toCROSS JOIN
a table to the last table added to theFROM
clause usingTable.crossJoin(String, Object...)
@NotNull SelectJoinStep<R>
Convenience method toCROSS JOIN
a table to the last table added to theFROM
clause usingTable.crossJoin(String, QueryPart...)
@NotNull SelectJoinStep<R>
Convenience method toCROSS JOIN
a table to the last table added to theFROM
clause usingTable.crossJoin(Name)
@NotNull SelectJoinStep<R>
Convenience method toCROSS JOIN
a table to the last table added to theFROM
clause usingTable.crossJoin(String)
@NotNull SelectJoinStep<R>
Convenience method toCROSS JOIN
a table to the last table added to theFROM
clause usingTable.crossJoin(TableLike)
@NotNull SelectOnStep<R>
Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterJoin(String)
.@NotNull SelectOnStep<R>
Convenience method toFULL OUTER JOIN
a tableto the last table added to theFROM
clause usingTable.fullOuterJoin(String, Object...)
.@NotNull SelectOnStep<R>
Convenience method toFULL OUTER JOIN
a tableto the last table added to theFROM
clause usingTable.fullOuterJoin(String, QueryPart...)
.@NotNull SelectOnStep<R>
Convenience method toFULL OUTER JOIN
a tableto the last table added to theFROM
clause usingTable.fullOuterJoin(Name)
.@NotNull SelectOnStep<R>
Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterJoin(String)
.@NotNull SelectOnStep<R>
Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterJoin(TableLike)
.@NotNull SelectOnStep<R>
fullOuterJoin
(String sql) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterJoin(String)
@NotNull SelectOnStep<R>
fullOuterJoin
(String sql, Object... bindings) Convenience method toFULL OUTER JOIN
a tableto the last table added to theFROM
clause usingTable.fullOuterJoin(String, Object...)
@NotNull SelectOnStep<R>
fullOuterJoin
(String sql, QueryPart... parts) Convenience method toFULL OUTER JOIN
a tableto the last table added to theFROM
clause usingTable.fullOuterJoin(String, QueryPart...)
@NotNull SelectOnStep<R>
fullOuterJoin
(Name name) Convenience method toFULL OUTER JOIN
a tableto the last table added to theFROM
clause usingTable.fullOuterJoin(Name)
@NotNull SelectOnStep<R>
fullOuterJoin
(SQL sql) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterJoin(String)
@NotNull SelectOnStep<R>
fullOuterJoin
(TableLike<?> table) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterJoin(TableLike)
@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String)
.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String, Object...)
.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String, QueryPart...)
.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(Name)
.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String)
.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(TableLike)
.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String)
.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String, Object...)
.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String, QueryPart...)
.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(Name)
.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String)
.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(TableLike)
.@NotNull SelectOptionalOnStep<R>
Convenience method to join a table to the last table added to theFROM
clause usingTable.join(TableLike, JoinType)
@NotNull SelectOnStep<R>
leftAntiJoin
(TableLike<?> table) A syntheticLEFT ANTI JOIN
clause that translates to an equivalentNOT EXISTS
predicate.@NotNull SelectJoinPartitionByStep<R>
Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String)
.@NotNull SelectJoinPartitionByStep<R>
Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String, Object...)
.@NotNull SelectJoinPartitionByStep<R>
Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String, QueryPart...)
.@NotNull SelectJoinPartitionByStep<R>
Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(Name)
.@NotNull SelectJoinPartitionByStep<R>
Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String)
.@NotNull SelectJoinPartitionByStep<R>
Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(TableLike)
.@NotNull SelectJoinPartitionByStep<R>
leftOuterJoin
(String sql) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String)
@NotNull SelectJoinPartitionByStep<R>
leftOuterJoin
(String sql, Object... bindings) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String, Object...)
@NotNull SelectJoinPartitionByStep<R>
leftOuterJoin
(String sql, QueryPart... parts) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String, QueryPart...)
@NotNull SelectJoinPartitionByStep<R>
leftOuterJoin
(Name name) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(Name)
@NotNull SelectJoinPartitionByStep<R>
leftOuterJoin
(SQL sql) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String)
@NotNull SelectJoinPartitionByStep<R>
leftOuterJoin
(TableLike<?> table) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(TableLike)
@NotNull SelectOnStep<R>
leftSemiJoin
(TableLike<?> table) A syntheticLEFT SEMI JOIN
clause that translates to an equivalentEXISTS
predicate.@NotNull SelectJoinStep<R>
Convenience method toNATURAL FULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalFullOuterJoin(String)
@NotNull SelectJoinStep<R>
naturalFullOuterJoin
(String sql, Object... bindings) Convenience method toNATURAL FULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalFullOuterJoin(String, Object...)
@NotNull SelectJoinStep<R>
naturalFullOuterJoin
(String sql, QueryPart... parts) Convenience method toNATURAL FULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalFullOuterJoin(String, QueryPart...)
@NotNull SelectJoinStep<R>
naturalFullOuterJoin
(Name name) Convenience method toNATURAL FULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalFullOuterJoin(Name)
@NotNull SelectJoinStep<R>
naturalFullOuterJoin
(SQL sql) Convenience method toNATURAL FULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalFullOuterJoin(String)
@NotNull SelectJoinStep<R>
naturalFullOuterJoin
(TableLike<?> table) Convenience method toNATURAL FULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalFullOuterJoin(TableLike)
@NotNull SelectJoinStep<R>
naturalJoin
(String sql) Convenience method toNATURAL JOIN
a table to the last table added to theFROM
clause usingTable.naturalJoin(String)
@NotNull SelectJoinStep<R>
naturalJoin
(String sql, Object... bindings) Convenience method toNATURAL JOIN
a table to the last table added to theFROM
clause usingTable.naturalJoin(String, Object...)
@NotNull SelectJoinStep<R>
naturalJoin
(String sql, QueryPart... parts) Convenience method toNATURAL JOIN
a table to the last table added to theFROM
clause usingTable.naturalJoin(String, QueryPart...)
@NotNull SelectJoinStep<R>
naturalJoin
(Name name) Convenience method toNATURAL JOIN
a table to the last table added to theFROM
clause usingTable.naturalJoin(Name)
@NotNull SelectJoinStep<R>
naturalJoin
(SQL sql) Convenience method toNATURAL JOIN
a table to the last table added to theFROM
clause usingTable.naturalJoin(String)
@NotNull SelectJoinStep<R>
naturalJoin
(TableLike<?> table) Convenience method toNATURAL JOIN
a table to the last table added to theFROM
clause usingTable.naturalJoin(TableLike)
@NotNull SelectJoinStep<R>
Convenience method toNATURAL LEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalLeftOuterJoin(String)
@NotNull SelectJoinStep<R>
naturalLeftOuterJoin
(String sql, Object... bindings) Convenience method toNATURAL LEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalLeftOuterJoin(String, Object...)
@NotNull SelectJoinStep<R>
naturalLeftOuterJoin
(String sql, QueryPart... parts) Convenience method toNATURAL LEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalLeftOuterJoin(String, QueryPart...)
@NotNull SelectJoinStep<R>
naturalLeftOuterJoin
(Name name) Convenience method toNATURAL LEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalLeftOuterJoin(Name)
@NotNull SelectJoinStep<R>
naturalLeftOuterJoin
(SQL sql) Convenience method toNATURAL LEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalLeftOuterJoin(String)
@NotNull SelectJoinStep<R>
naturalLeftOuterJoin
(TableLike<?> table) Convenience method toNATURAL LEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalLeftOuterJoin(TableLike)
@NotNull SelectJoinStep<R>
Convenience method toNATURAL RIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalRightOuterJoin(String)
@NotNull SelectJoinStep<R>
naturalRightOuterJoin
(String sql, Object... bindings) Convenience method toNATURAL RIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalRightOuterJoin(String, Object...)
@NotNull SelectJoinStep<R>
naturalRightOuterJoin
(String sql, QueryPart... parts) Convenience method toNATURAL RIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalRightOuterJoin(String, QueryPart...)
@NotNull SelectJoinStep<R>
naturalRightOuterJoin
(Name name) Convenience method toNATURAL RIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalRightOuterJoin(Name)
@NotNull SelectJoinStep<R>
naturalRightOuterJoin
(SQL sql) Convenience method toNATURAL RIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalRightOuterJoin(String)
@NotNull SelectJoinStep<R>
naturalRightOuterJoin
(TableLike<?> table) Convenience method toNATURAL RIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalRightOuterJoin(TableLike)
@NotNull SelectJoinStep<R>
outerApply
(String sql) OUTER APPLY
a table to this table.@NotNull SelectJoinStep<R>
outerApply
(String sql, Object... bindings) OUTER APPLY
a table to this table.@NotNull SelectJoinStep<R>
outerApply
(String sql, QueryPart... parts) OUTER APPLY
a table to this table.@NotNull SelectJoinStep<R>
outerApply
(Name name) OUTER APPLY
a table to this table.@NotNull SelectJoinStep<R>
outerApply
(SQL sql) OUTER APPLY
a table to this table.@NotNull SelectJoinStep<R>
outerApply
(TableLike<?> table) OUTER APPLY
a table to this table.@NotNull SelectJoinPartitionByStep<R>
Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String)
.@NotNull SelectJoinPartitionByStep<R>
Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String, Object...)
.@NotNull SelectJoinPartitionByStep<R>
Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String, QueryPart...)
.@NotNull SelectJoinPartitionByStep<R>
Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(Name)
.@NotNull SelectJoinPartitionByStep<R>
Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String)
.@NotNull SelectJoinPartitionByStep<R>
Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(TableLike)
.@NotNull SelectJoinPartitionByStep<R>
rightOuterJoin
(String sql) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String)
@NotNull SelectJoinPartitionByStep<R>
rightOuterJoin
(String sql, Object... bindings) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String, Object...)
@NotNull SelectJoinPartitionByStep<R>
rightOuterJoin
(String sql, QueryPart... parts) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String, QueryPart...)
@NotNull SelectJoinPartitionByStep<R>
rightOuterJoin
(Name name) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(Name)
@NotNull SelectJoinPartitionByStep<R>
rightOuterJoin
(SQL sql) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String)
@NotNull SelectJoinPartitionByStep<R>
rightOuterJoin
(TableLike<?> table) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(TableLike)
@NotNull SelectOnStep<R>
straightJoin
(String sql) STRAIGHT_JOIN
a table to this table.@NotNull SelectOnStep<R>
straightJoin
(String sql, Object... bindings) STRAIGHT_JOIN
a table to this table.@NotNull SelectOnStep<R>
straightJoin
(String sql, QueryPart... parts) STRAIGHT_JOIN
a table to this table.@NotNull SelectOnStep<R>
straightJoin
(Name name) STRAIGHT_JOIN
a table to this table.@NotNull SelectOnStep<R>
straightJoin
(SQL sql) STRAIGHT_JOIN
a table to this table.@NotNull SelectOnStep<R>
straightJoin
(TableLike<?> table) STRAIGHT_JOIN
a table to this table.Methods inherited from interface org.jooq.Attachable
attach, configuration, detach
Methods inherited from interface org.jooq.AttachableQueryPart
getBindValues, getParam, getParams, getSQL, getSQL
Methods inherited from interface org.jooq.Fields
dataType, dataType, dataType, dataTypes, field, field, field, field, field, field, field, field, field, field, fields, fields, fields, fields, fields, fieldsRow, fieldStream, indexOf, indexOf, indexOf, type, type, type, types
Methods inherited from interface org.reactivestreams.Publisher
subscribe
Methods inherited from interface org.jooq.Query
cancel, execute, executeAsync, executeAsync, isExecutable
Methods inherited from interface org.jooq.QueryPart
$replace, $replace, $traverse, $traverse, equals, hashCode, toString
Methods inherited from interface org.jooq.ResultQuery
bind, bind, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, coerce, collect, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAny, fetchAnyArray, fetchAnyInto, fetchAnyInto, fetchAnyMap, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArrays, fetchAsync, fetchAsync, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchInto, fetchInto, fetchInto, fetchLazy, fetchMany, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMaps, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOneArray, fetchOneInto, fetchOneInto, fetchOneMap, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptional, fetchOptionalArray, fetchOptionalInto, fetchOptionalInto, fetchOptionalMap, fetchResultSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSet, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingle, fetchSingleArray, fetchSingleInto, fetchSingleInto, fetchSingleMap, fetchSize, fetchStream, fetchStreamInto, fetchStreamInto, forEach, getRecordType, getResult, intern, intern, intern, intern, iterator, keepStatement, maxRows, poolable, queryTimeout, resultSetConcurrency, resultSetHoldability, resultSetType, spliterator, stream
Methods inherited from interface org.jooq.Select
$connectBy, $connectBy, $connectByNoCycle, $connectByNoCycle, $connectByStartWith, $connectByStartWith, $distinct, $distinct, $from, $from, $groupBy, $groupBy, $groupByDistinct, $groupByDistinct, $having, $having, $limit, $limit, $limitPercent, $limitPercent, $limitWithTies, $limitWithTies, $offset, $offset, $orderBy, $orderBy, $qualify, $qualify, $select, $select, $where, $where, $window, $window, $with, getSelect
Methods inherited from interface org.jooq.SelectConnectByStep
connectBy, connectBy, connectBy, connectBy, connectBy, connectBy, connectByNoCycle, connectByNoCycle, connectByNoCycle, connectByNoCycle, connectByNoCycle, connectByNoCycle, startWith, startWith, startWith, startWith, startWith, startWith
Methods inherited from interface org.jooq.SelectCorrelatedSubqueryStep
between, between, between, between, betweenSymmetric, betweenSymmetric, betweenSymmetric, betweenSymmetric, compare, compare, compare, eq, eq, eq, equal, equal, equal, ge, ge, ge, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterThan, greaterThan, greaterThan, gt, gt, gt, in, in, isDistinctFrom, isDistinctFrom, isDistinctFrom, isNotDistinctFrom, isNotDistinctFrom, isNotDistinctFrom, isNotNull, isNull, le, le, le, lessOrEqual, lessOrEqual, lessOrEqual, lessThan, lessThan, lessThan, lt, lt, lt, ne, ne, ne, notBetween, notBetween, notBetween, notBetween, notBetweenSymmetric, notBetweenSymmetric, notBetweenSymmetric, notBetweenSymmetric, notEqual, notEqual, notEqual, notIn, notIn
Methods inherited from interface org.jooq.SelectFinalStep
getQuery
Methods inherited from interface org.jooq.SelectForStep
forJSON, forJSONB, forXML
Methods inherited from interface org.jooq.SelectForUpdateStep
forKeyShare, forNoKeyUpdate, forShare, forUpdate, withCheckOption, withReadOnly
Methods inherited from interface org.jooq.SelectGroupByStep
groupBy, groupBy, groupByDistinct, groupByDistinct
Methods inherited from interface org.jooq.SelectHavingStep
having, having, having, having, having, having, having, having
Methods inherited from interface org.jooq.SelectLimitStep
limit, limit, limit, limit, limit, limit, offset, offset
Methods inherited from interface org.jooq.SelectOptionStep
option
Methods inherited from interface org.jooq.SelectOrderByStep
orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderSiblingsBy, orderSiblingsBy, orderSiblingsBy
Methods inherited from interface org.jooq.SelectQualifyStep
qualify, qualify, qualify, qualify, qualify, qualify, qualify, qualify
Methods inherited from interface org.jooq.SelectUnionStep
except, exceptAll, intersect, intersectAll, union, unionAll
Methods inherited from interface org.jooq.SelectWhereStep
where, where, where, where, where, where, where, where, whereExists, whereNotExists
Methods inherited from interface org.jooq.SelectWindowStep
window, window
Methods inherited from interface org.jooq.TableLike
asMultiset, asMultiset, asMultiset, asMultiset, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable
-
Method Details
-
join
@NotNull @CheckReturnValue @Support @NotNull SelectOptionalOnStep<R> join(TableLike<?> table, JoinType type) Convenience method to join a table to the last table added to theFROM
clause usingTable.join(TableLike, JoinType)
Depending on the
JoinType
, a subsequentSelectOnStep.on(Condition)
orSelectOnStep.using(Field...)
clause is required. If it is required but omitted, the JOIN clause will be ignored -
join
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(TableLike)
.A synonym for
innerJoin(TableLike)
.- See Also:
-
join
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String)
.A synonym for
innerJoin(String)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
join
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String)
.A synonym for
innerJoin(String)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
join
@NotNull @CheckReturnValue @Support @PlainSQL @NotNull SelectOnStep<R> join(String sql, Object... bindings) Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String, Object...)
.A synonym for
innerJoin(String, Object...)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
join
@NotNull @CheckReturnValue @Support @PlainSQL @NotNull SelectOnStep<R> join(String sql, QueryPart... parts) Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String, QueryPart...)
.A synonym for
innerJoin(String, QueryPart...)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
join
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(Name)
.A synonym for
innerJoin(Name)
.- See Also:
-
innerJoin
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(TableLike)
.- See Also:
-
innerJoin
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
innerJoin
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
innerJoin
@NotNull @CheckReturnValue @Support @PlainSQL @NotNull SelectOnStep<R> innerJoin(String sql, Object... bindings) Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String, Object...)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
innerJoin
@NotNull @CheckReturnValue @Support @PlainSQL @NotNull SelectOnStep<R> innerJoin(String sql, QueryPart... parts) Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String, QueryPart...)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
innerJoin
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(Name)
.- See Also:
-
crossJoin
@NotNull @CheckReturnValue @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull SelectJoinStep<R> crossJoin(TableLike<?> table) Convenience method toCROSS JOIN
a table to the last table added to theFROM
clause usingTable.crossJoin(TableLike)
If this syntax is unavailable, it is emulated with a regular
INNER JOIN
. The following two constructs are equivalent:A cross join B A join B on 1 = 1
- See Also:
-
crossJoin
@NotNull @CheckReturnValue @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinStep<R> crossJoin(SQL sql) Convenience method toCROSS JOIN
a table to the last table added to theFROM
clause usingTable.crossJoin(String)
If this syntax is unavailable, it is emulated with a regular
INNER JOIN
. The following two constructs are equivalent:A cross join B A join B on 1 = 1
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
crossJoin
@NotNull @CheckReturnValue @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinStep<R> crossJoin(String sql) Convenience method toCROSS JOIN
a table to the last table added to theFROM
clause usingTable.crossJoin(String)
If this syntax is unavailable, it is emulated with a regular
INNER JOIN
. The following two constructs are equivalent:A cross join B A join B on 1 = 1
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
crossJoin
@NotNull @CheckReturnValue @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinStep<R> crossJoin(String sql, Object... bindings) Convenience method toCROSS JOIN
a table to the last table added to theFROM
clause usingTable.crossJoin(String, Object...)
If this syntax is unavailable, it is emulated with a regular
INNER JOIN
. The following two constructs are equivalent:A cross join B A join B on 1 = 1
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
crossJoin
@NotNull @CheckReturnValue @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinStep<R> crossJoin(String sql, QueryPart... parts) Convenience method toCROSS JOIN
a table to the last table added to theFROM
clause usingTable.crossJoin(String, QueryPart...)
If this syntax is unavailable, it is emulated with a regular
INNER JOIN
. The following two constructs are equivalent:A cross join B A join B on 1 = 1
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
crossJoin
@NotNull @CheckReturnValue @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull SelectJoinStep<R> crossJoin(Name name) Convenience method toCROSS JOIN
a table to the last table added to theFROM
clause usingTable.crossJoin(Name)
If this syntax is unavailable, it is emulated with a regular
INNER JOIN
. The following two constructs are equivalent:A cross join B A join B on 1 = 1
- See Also:
-
leftJoin
@NotNull @CheckReturnValue @Support @NotNull SelectJoinPartitionByStep<R> leftJoin(TableLike<?> table) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(TableLike)
.A synonym for
leftOuterJoin(TableLike)
. -
leftJoin
@NotNull @CheckReturnValue @Support @PlainSQL @NotNull SelectJoinPartitionByStep<R> leftJoin(SQL sql) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String)
.A synonym for
leftOuterJoin(String)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
leftJoin
@NotNull @CheckReturnValue @Support @PlainSQL @NotNull SelectJoinPartitionByStep<R> leftJoin(String sql) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String)
.A synonym for
leftOuterJoin(String)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
leftJoin
@NotNull @CheckReturnValue @Support @PlainSQL @NotNull SelectJoinPartitionByStep<R> leftJoin(String sql, Object... bindings) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String, Object...)
.A synonym for
leftOuterJoin(String, Object...)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
leftJoin
@NotNull @CheckReturnValue @Support @PlainSQL @NotNull SelectJoinPartitionByStep<R> leftJoin(String sql, QueryPart... parts) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String, QueryPart...)
.A synonym for
leftOuterJoin(String, QueryPart...)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
leftJoin
Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(Name)
.A synonym for
leftOuterJoin(Name)
. -
leftOuterJoin
@NotNull @CheckReturnValue @Support @NotNull SelectJoinPartitionByStep<R> leftOuterJoin(TableLike<?> table) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(TableLike)
- See Also:
-
leftOuterJoin
@NotNull @CheckReturnValue @Support @PlainSQL @NotNull SelectJoinPartitionByStep<R> leftOuterJoin(SQL sql) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String)
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
leftOuterJoin
@NotNull @CheckReturnValue @Support @PlainSQL @NotNull SelectJoinPartitionByStep<R> leftOuterJoin(String sql) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String)
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
leftOuterJoin
@NotNull @CheckReturnValue @Support @PlainSQL @NotNull SelectJoinPartitionByStep<R> leftOuterJoin(String sql, Object... bindings) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String, Object...)
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
leftOuterJoin
@NotNull @CheckReturnValue @Support @PlainSQL @NotNull SelectJoinPartitionByStep<R> leftOuterJoin(String sql, QueryPart... parts) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String, QueryPart...)
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
leftOuterJoin
Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(Name)
- See Also:
-
rightJoin
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull SelectJoinPartitionByStep<R> rightJoin(TableLike<?> table) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(TableLike)
.A synonym for
rightOuterJoin(TableLike)
.This is only possible where the underlying RDBMS supports it
-
rightJoin
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinPartitionByStep<R> rightJoin(SQL sql) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String)
.A synonym for
rightOuterJoin(String)
.This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
rightJoin
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinPartitionByStep<R> rightJoin(String sql) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String)
.A synonym for
rightOuterJoin(String)
.This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
rightJoin
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinPartitionByStep<R> rightJoin(String sql, Object... bindings) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String, Object...)
.A synonym for
rightOuterJoin(String, Object...)
.This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
rightJoin
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinPartitionByStep<R> rightJoin(String sql, QueryPart... parts) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String, QueryPart...)
.A synonym for
rightOuterJoin(String, QueryPart...)
.This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
rightJoin
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull SelectJoinPartitionByStep<R> rightJoin(Name name) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(Name)
.A synonym for
rightOuterJoin(Name)
.This is only possible where the underlying RDBMS supports it
-
rightOuterJoin
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull SelectJoinPartitionByStep<R> rightOuterJoin(TableLike<?> table) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(TableLike)
This is only possible where the underlying RDBMS supports it
- See Also:
-
rightOuterJoin
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinPartitionByStep<R> rightOuterJoin(SQL sql) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String)
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
rightOuterJoin
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinPartitionByStep<R> rightOuterJoin(String sql) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String)
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
rightOuterJoin
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinPartitionByStep<R> rightOuterJoin(String sql, Object... bindings) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String, Object...)
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
rightOuterJoin
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinPartitionByStep<R> rightOuterJoin(String sql, QueryPart... parts) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String, QueryPart...)
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
rightOuterJoin
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull SelectJoinPartitionByStep<R> rightOuterJoin(Name name) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(Name)
This is only possible where the underlying RDBMS supports it
- See Also:
-
fullJoin
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull SelectOnStep<R> fullJoin(TableLike<?> table) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterJoin(TableLike)
.A synonym for
fullOuterJoin(TableLike)
. -
fullJoin
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectOnStep<R> fullJoin(SQL sql) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterJoin(String)
.A synonym for
fullOuterJoin(SQL)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
fullJoin
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectOnStep<R> fullJoin(String sql) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterJoin(String)
.A synonym for
fullOuterJoin(String)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
fullJoin
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectOnStep<R> fullJoin(String sql, Object... bindings) Convenience method toFULL OUTER JOIN
a tableto the last table added to theFROM
clause usingTable.fullOuterJoin(String, Object...)
.A synonym for
fullOuterJoin(String, Object...)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
fullJoin
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectOnStep<R> fullJoin(String sql, QueryPart... parts) Convenience method toFULL OUTER JOIN
a tableto the last table added to theFROM
clause usingTable.fullOuterJoin(String, QueryPart...)
.A synonym for
fullOuterJoin(String, QueryPart...)
.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
fullJoin
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull SelectOnStep<R> fullJoin(Name name) Convenience method toFULL OUTER JOIN
a tableto the last table added to theFROM
clause usingTable.fullOuterJoin(Name)
.A synonym for
fullOuterJoin(Name)
. -
fullOuterJoin
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull SelectOnStep<R> fullOuterJoin(TableLike<?> table) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterJoin(TableLike)
This is only possible where the underlying RDBMS supports it
- See Also:
-
fullOuterJoin
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectOnStep<R> fullOuterJoin(SQL sql) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterJoin(String)
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
fullOuterJoin
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectOnStep<R> fullOuterJoin(String sql) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterJoin(String)
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
fullOuterJoin
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectOnStep<R> fullOuterJoin(String sql, Object... bindings) Convenience method toFULL OUTER JOIN
a tableto the last table added to theFROM
clause usingTable.fullOuterJoin(String, Object...)
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
fullOuterJoin
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectOnStep<R> fullOuterJoin(String sql, QueryPart... parts) Convenience method toFULL OUTER JOIN
a tableto the last table added to theFROM
clause usingTable.fullOuterJoin(String, QueryPart...)
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
fullOuterJoin
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull SelectOnStep<R> fullOuterJoin(Name name) Convenience method toFULL OUTER JOIN
a tableto the last table added to theFROM
clause usingTable.fullOuterJoin(Name)
This is only possible where the underlying RDBMS supports it
- See Also:
-
naturalJoin
Convenience method toNATURAL JOIN
a table to the last table added to theFROM
clause usingTable.naturalJoin(TableLike)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
- See Also:
-
naturalJoin
Convenience method toNATURAL JOIN
a table to the last table added to theFROM
clause usingTable.naturalJoin(String)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
naturalJoin
Convenience method toNATURAL JOIN
a table to the last table added to theFROM
clause usingTable.naturalJoin(String)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
naturalJoin
@NotNull @CheckReturnValue @Support @PlainSQL @NotNull SelectJoinStep<R> naturalJoin(String sql, Object... bindings) Convenience method toNATURAL JOIN
a table to the last table added to theFROM
clause usingTable.naturalJoin(String, Object...)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
naturalJoin
@NotNull @CheckReturnValue @Support @PlainSQL @NotNull SelectJoinStep<R> naturalJoin(String sql, QueryPart... parts) Convenience method toNATURAL JOIN
a table to the last table added to theFROM
clause usingTable.naturalJoin(String, QueryPart...)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
naturalJoin
Convenience method toNATURAL JOIN
a table to the last table added to theFROM
clause usingTable.naturalJoin(Name)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
- See Also:
-
naturalLeftOuterJoin
@NotNull @CheckReturnValue @Support @NotNull SelectJoinStep<R> naturalLeftOuterJoin(TableLike<?> table) Convenience method toNATURAL LEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalLeftOuterJoin(TableLike)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
- See Also:
-
naturalLeftOuterJoin
@NotNull @CheckReturnValue @Support @PlainSQL @NotNull SelectJoinStep<R> naturalLeftOuterJoin(SQL sql) Convenience method toNATURAL LEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalLeftOuterJoin(String)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
naturalLeftOuterJoin
@NotNull @CheckReturnValue @Support @PlainSQL @NotNull SelectJoinStep<R> naturalLeftOuterJoin(String sql) Convenience method toNATURAL LEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalLeftOuterJoin(String)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
naturalLeftOuterJoin
@NotNull @CheckReturnValue @Support @PlainSQL @NotNull SelectJoinStep<R> naturalLeftOuterJoin(String sql, Object... bindings) Convenience method toNATURAL LEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalLeftOuterJoin(String, Object...)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
naturalLeftOuterJoin
@NotNull @CheckReturnValue @Support @PlainSQL @NotNull SelectJoinStep<R> naturalLeftOuterJoin(String sql, QueryPart... parts) Convenience method toNATURAL LEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalLeftOuterJoin(String, QueryPart...)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
naturalLeftOuterJoin
Convenience method toNATURAL LEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalLeftOuterJoin(Name)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
-
naturalRightOuterJoin
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull SelectJoinStep<R> naturalRightOuterJoin(TableLike<?> table) Convenience method toNATURAL RIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalRightOuterJoin(TableLike)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
- See Also:
-
naturalRightOuterJoin
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinStep<R> naturalRightOuterJoin(SQL sql) Convenience method toNATURAL RIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalRightOuterJoin(String)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
naturalRightOuterJoin
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinStep<R> naturalRightOuterJoin(String sql) Convenience method toNATURAL RIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalRightOuterJoin(String)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
naturalRightOuterJoin
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinStep<R> naturalRightOuterJoin(String sql, Object... bindings) Convenience method toNATURAL RIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalRightOuterJoin(String, Object...)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
naturalRightOuterJoin
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinStep<R> naturalRightOuterJoin(String sql, QueryPart... parts) Convenience method toNATURAL RIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalRightOuterJoin(String, QueryPart...)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
naturalRightOuterJoin
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull SelectJoinStep<R> naturalRightOuterJoin(Name name) Convenience method toNATURAL RIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalRightOuterJoin(Name)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
-
naturalFullOuterJoin
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull SelectJoinStep<R> naturalFullOuterJoin(TableLike<?> table) Convenience method toNATURAL FULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalFullOuterJoin(TableLike)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
- See Also:
-
naturalFullOuterJoin
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinStep<R> naturalFullOuterJoin(SQL sql) Convenience method toNATURAL FULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalFullOuterJoin(String)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
naturalFullOuterJoin
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinStep<R> naturalFullOuterJoin(String sql) Convenience method toNATURAL FULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalFullOuterJoin(String)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
naturalFullOuterJoin
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinStep<R> naturalFullOuterJoin(String sql, Object... bindings) Convenience method toNATURAL FULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalFullOuterJoin(String, Object...)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
naturalFullOuterJoin
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinStep<R> naturalFullOuterJoin(String sql, QueryPart... parts) Convenience method toNATURAL FULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalFullOuterJoin(String, QueryPart...)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
naturalFullOuterJoin
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull SelectJoinStep<R> naturalFullOuterJoin(Name name) Convenience method toNATURAL FULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalFullOuterJoin(Name)
Natural joins are supported by most RDBMS. If they aren't supported, they are emulated if jOOQ has enough information.
-
leftSemiJoin
A syntheticLEFT SEMI JOIN
clause that translates to an equivalentEXISTS
predicate.The following two SQL snippets are semantically equivalent:
-- Using LEFT SEMI JOIN FROM A LEFT SEMI JOIN B ON A.ID = B.ID -- Using WHERE EXISTS FROM A WHERE EXISTS ( SELECT 1 FROM B WHERE A.ID = B.ID )
Notice that according to Relational algebra's understanding of left semi join, the right hand side of the left semi join operator is not projected, i.e. it cannot be accessed from
WHERE
orSELECT
or any other clause thanON
.- See Also:
-
leftAntiJoin
A syntheticLEFT ANTI JOIN
clause that translates to an equivalentNOT EXISTS
predicate.The following two SQL snippets are semantically equivalent:
-- Using LEFT ANTI JOIN FROM A LEFT ANTI JOIN B ON A.ID = B.ID -- Using WHERE NOT EXISTS FROM A WHERE NOT EXISTS ( SELECT 1 FROM B WHERE A.ID = B.ID )
Notice that according to Relational algebra's understanding of left semi join, the right hand side of the left semi join operator is not projected, i.e. it cannot be accessed from
WHERE
orSELECT
or any other clause thanON
.- See Also:
-
crossApply
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,DB2,FIREBIRD_4_0,ORACLE12C,POSTGRES_9_3,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,YUGABYTEDB}) @NotNull SelectJoinStep<R> crossApply(TableLike<?> table) CROSS APPLY
a table to this table.- See Also:
-
crossApply
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,DB2,FIREBIRD_4_0,ORACLE12C,POSTGRES_9_3,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinStep<R> crossApply(SQL sql) CROSS APPLY
a table to this table.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
crossApply
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,DB2,FIREBIRD_4_0,ORACLE12C,POSTGRES_9_3,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinStep<R> crossApply(String sql) CROSS APPLY
a table to this table.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
crossApply
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,DB2,FIREBIRD_4_0,ORACLE12C,POSTGRES_9_3,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinStep<R> crossApply(String sql, Object... bindings) CROSS APPLY
a table to this table.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
crossApply
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,DB2,FIREBIRD_4_0,ORACLE12C,POSTGRES_9_3,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinStep<R> crossApply(String sql, QueryPart... parts) CROSS APPLY
a table to this table.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
crossApply
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,DB2,FIREBIRD_4_0,ORACLE12C,POSTGRES_9_3,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,YUGABYTEDB}) @NotNull SelectJoinStep<R> crossApply(Name name) CROSS APPLY
a table to this table.- See Also:
-
outerApply
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,DB2,FIREBIRD_4_0,ORACLE12C,POSTGRES_9_3,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,YUGABYTEDB}) @NotNull SelectJoinStep<R> outerApply(TableLike<?> table) OUTER APPLY
a table to this table.- See Also:
-
outerApply
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,DB2,FIREBIRD_4_0,ORACLE12C,POSTGRES_9_3,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinStep<R> outerApply(SQL sql) OUTER APPLY
a table to this table.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
outerApply
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,DB2,FIREBIRD_4_0,ORACLE12C,POSTGRES_9_3,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinStep<R> outerApply(String sql) OUTER APPLY
a table to this table.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
outerApply
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,DB2,FIREBIRD_4_0,ORACLE12C,POSTGRES_9_3,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinStep<R> outerApply(String sql, Object... bindings) OUTER APPLY
a table to this table.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
outerApply
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,DB2,FIREBIRD_4_0,ORACLE12C,POSTGRES_9_3,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,YUGABYTEDB}) @PlainSQL @NotNull SelectJoinStep<R> outerApply(String sql, QueryPart... parts) OUTER APPLY
a table to this table.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
outerApply
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,DB2,FIREBIRD_4_0,ORACLE12C,POSTGRES_9_3,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,YUGABYTEDB}) @NotNull SelectJoinStep<R> outerApply(Name name) OUTER APPLY
a table to this table.- See Also:
-
straightJoin
@NotNull @CheckReturnValue @Support({MEMSQL,MYSQL}) @NotNull SelectOnStep<R> straightJoin(TableLike<?> table) STRAIGHT_JOIN
a table to this table.- See Also:
-
straightJoin
@NotNull @CheckReturnValue @Support({MEMSQL,MYSQL}) @PlainSQL @NotNull SelectOnStep<R> straightJoin(SQL sql) STRAIGHT_JOIN
a table to this table.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
straightJoin
@NotNull @CheckReturnValue @Support({MEMSQL,MYSQL}) @PlainSQL @NotNull SelectOnStep<R> straightJoin(String sql) STRAIGHT_JOIN
a table to this table.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
- See Also:
-
straightJoin
@NotNull @CheckReturnValue @Support({MEMSQL,MYSQL}) @PlainSQL @NotNull SelectOnStep<R> straightJoin(String sql, Object... bindings) STRAIGHT_JOIN
a table to this table.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
straightJoin
@NotNull @CheckReturnValue @Support({MEMSQL,MYSQL}) @PlainSQL @NotNull SelectOnStep<R> straightJoin(String sql, QueryPart... parts) STRAIGHT_JOIN
a table to this table.NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
-
straightJoin
@NotNull @CheckReturnValue @Support({MEMSQL,MYSQL}) @NotNull SelectOnStep<R> straightJoin(Name name) STRAIGHT_JOIN
a table to this table.- See Also:
-