Package | Description |
---|---|
org.jooq |
The
org.jooq package contains jOOQ's public API. |
Modifier and Type | Interface and Description |
---|---|
interface |
SelectOnConditionStep<R extends Record>
|
interface |
SelectOptionalOnStep<R extends Record>
|
Modifier and Type | Method and Description |
---|---|
SelectJoinStep<R> |
SelectJoinStep.crossApply(Name name)
CROSS APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossApply(SQL sql)
CROSS APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossApply(String sql)
CROSS APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossApply(String sql,
Object... bindings)
CROSS APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossApply(String sql,
QueryPart... parts)
CROSS APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossApply(TableLike<?> table)
CROSS APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossJoin(Name name)
Convenience method to
CROSS JOIN a table to the last table
added to the FROM clause using
Table.crossJoin(Name)
If this syntax is unavailable, it is emulated with a regular
INNER JOIN . |
SelectJoinStep<R> |
SelectJoinStep.crossJoin(SQL sql)
Convenience method to
CROSS JOIN a table to the last table
added to the FROM clause using
Table.crossJoin(String)
If this syntax is unavailable, it is emulated with a regular
INNER JOIN . |
SelectJoinStep<R> |
SelectJoinStep.crossJoin(String sql)
Convenience method to
CROSS JOIN a table to the last table
added to the FROM clause using
Table.crossJoin(String)
If this syntax is unavailable, it is emulated with a regular
INNER JOIN . |
SelectJoinStep<R> |
SelectJoinStep.crossJoin(String sql,
Object... bindings)
Convenience method to
CROSS JOIN a table to the last table
added to the FROM clause using
Table.crossJoin(String, Object...) |
SelectJoinStep<R> |
SelectJoinStep.crossJoin(String sql,
QueryPart... parts)
Convenience method to
CROSS JOIN a table to the last table
added to the FROM clause using
Table.crossJoin(String, QueryPart...) |
SelectJoinStep<R> |
SelectJoinStep.crossJoin(TableLike<?> table)
Convenience method to
CROSS JOIN a table to the last table
added to the FROM clause using
Table.crossJoin(TableLike)
If this syntax is unavailable, it is emulated with a regular
INNER JOIN . |
SelectJoinStep<R> |
SelectFromStep.from(Collection<? extends TableLike<?>> tables)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectFromStep.from(Name name)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectFromStep.from(SQL sql)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectFromStep.from(String sql)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectFromStep.from(String sql,
Object... bindings)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectFromStep.from(String sql,
QueryPart... parts)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectFromStep.from(TableLike<?>... tables)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectFromStep.from(TableLike<?> table)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectJoinStep.naturalJoin(Name name)
Convenience method to
NATURAL JOIN a table to the last table
added to the FROM clause using
Table.naturalJoin(Name)
Natural joins are supported by most RDBMS. |
SelectJoinStep<R> |
SelectJoinStep.naturalJoin(SQL sql)
Convenience method to
NATURAL JOIN a table to the last table
added to the FROM clause using
Table.naturalJoin(String)
Natural joins are supported by most RDBMS. |
SelectJoinStep<R> |
SelectJoinStep.naturalJoin(String sql)
Convenience method to
NATURAL JOIN a table to the last table
added to the FROM clause using
Table.naturalJoin(String)
Natural joins are supported by most RDBMS. |
SelectJoinStep<R> |
SelectJoinStep.naturalJoin(String sql,
Object... bindings)
Convenience method to
NATURAL JOIN a table to the last table
added to the FROM clause using
Table.naturalJoin(String, Object...) |
SelectJoinStep<R> |
SelectJoinStep.naturalJoin(String sql,
QueryPart... parts)
Convenience method to
NATURAL JOIN a table to the last table
added to the FROM clause using
Table.naturalJoin(String, QueryPart...) |
SelectJoinStep<R> |
SelectJoinStep.naturalJoin(TableLike<?> table)
Convenience method to
NATURAL JOIN a table to the last table
added to the FROM clause using
Table.naturalJoin(TableLike)
Natural joins are supported by most RDBMS. |
SelectJoinStep<R> |
SelectJoinStep.naturalLeftOuterJoin(Name name)
Convenience method to
NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table.naturalLeftOuterJoin(Name)
Natural joins are supported by most RDBMS. |
SelectJoinStep<R> |
SelectJoinStep.naturalLeftOuterJoin(SQL sql)
Convenience method to
NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table.naturalLeftOuterJoin(String)
Natural joins are supported by most RDBMS. |
SelectJoinStep<R> |
SelectJoinStep.naturalLeftOuterJoin(String sql)
Convenience method to
NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table.naturalLeftOuterJoin(String)
Natural joins are supported by most RDBMS. |
SelectJoinStep<R> |
SelectJoinStep.naturalLeftOuterJoin(String sql,
Object... bindings)
Convenience method to
NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table.naturalLeftOuterJoin(String, Object...) |
SelectJoinStep<R> |
SelectJoinStep.naturalLeftOuterJoin(String sql,
QueryPart... parts)
Convenience method to
NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table.naturalLeftOuterJoin(String, QueryPart...) |
SelectJoinStep<R> |
SelectJoinStep.naturalLeftOuterJoin(TableLike<?> table)
Convenience method to
NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table.naturalLeftOuterJoin(TableLike)
Natural joins are supported by most RDBMS. |
SelectJoinStep<R> |
SelectJoinStep.naturalRightOuterJoin(Name name)
Convenience method to
NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table.naturalRightOuterJoin(Name)
Natural joins are supported by most RDBMS. |
SelectJoinStep<R> |
SelectJoinStep.naturalRightOuterJoin(SQL sql)
Convenience method to
NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table.naturalRightOuterJoin(String)
Natural joins are supported by most RDBMS. |
SelectJoinStep<R> |
SelectJoinStep.naturalRightOuterJoin(String sql)
Convenience method to
NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table.naturalRightOuterJoin(String)
Natural joins are supported by most RDBMS. |
SelectJoinStep<R> |
SelectJoinStep.naturalRightOuterJoin(String sql,
Object... bindings)
Convenience method to
NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table.naturalRightOuterJoin(String, Object...) |
SelectJoinStep<R> |
SelectJoinStep.naturalRightOuterJoin(String sql,
QueryPart... parts)
Convenience method to
NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table.naturalRightOuterJoin(String, QueryPart...) |
SelectJoinStep<R> |
SelectJoinStep.naturalRightOuterJoin(TableLike<?> table)
Convenience method to
NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table.naturalRightOuterJoin(TableLike)
Natural joins are supported by most RDBMS. |
SelectJoinStep<R> |
SelectOnStep.onKey()
Join the previous table on a non-ambiguous foreign key relationship
between the two joined tables.
|
SelectJoinStep<R> |
SelectOnStep.onKey(ForeignKey<?,?> key)
Join the table on a non-ambiguous foreign key relationship between the
two joined tables.
|
SelectJoinStep<R> |
SelectOnStep.onKey(TableField<?,?>... keyFields)
Join the previous table on a non-ambiguous foreign key relationship
between the two joined tables.
|
SelectJoinStep<R> |
SelectJoinStep.outerApply(Name name)
OUTER APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.outerApply(SQL sql)
OUTER APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.outerApply(String sql)
OUTER APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.outerApply(String sql,
Object... bindings)
OUTER APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.outerApply(String sql,
QueryPart... parts)
OUTER APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.outerApply(TableLike<?> table)
OUTER APPLY a table to this table. |
SelectJoinStep<R> |
SelectOnStep.using(Collection<? extends Field<?>> fields)
Join the previous table with the
USING(column [, column...]) |
SelectJoinStep<R> |
SelectOnStep.using(Field<?>... fields)
Join the previous table with the
USING(column [, column...]) |
Copyright © 2019. All rights reserved.