Uses of Interface
org.jooq.TableLike
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of TableLike in org.jooq
Modifier and TypeInterfaceDescriptioninterface
CommonTableExpression<R extends Record>
A common table expression.interface
A step in the construction of anJSON_TABLE
expression.interface
A step in the construction of anJSON_TABLE
expression.interface
A relationship path.interface
ASELECT
statement.interface
SelectConditionStep<R extends Record>
interface
SelectConnectByAfterStartWithConditionStep<R extends Record>
interface
SelectConnectByConditionStep<R extends Record>
interface
SelectConnectByStep<R extends Record>
interface
SelectCorrelatedSubqueryStep<R extends Record>
interface
SelectDistinctOnStep<R extends Record>
interface
SelectFinalStep<R extends Record>
interface
SelectForJSONCommonDirectivesStep<R extends Record>
interface
SelectForStep<R extends Record>
interface
SelectForUpdateOfStep<R extends Record>
interface
SelectForUpdateStep<R extends Record>
interface
SelectForUpdateWaitStep<R extends Record>
interface
SelectForXMLCommonDirectivesStep<R extends Record>
interface
SelectForXMLPathDirectivesStep<R extends Record>
interface
SelectForXMLRawDirectivesStep<R extends Record>
interface
SelectFromStep<R extends Record>
interface
SelectGroupByStep<R extends Record>
interface
SelectHavingConditionStep<R extends Record>
interface
SelectHavingStep<R extends Record>
interface
SelectIntoStep<R extends Record>
interface
SelectJoinStep<R extends Record>
interface
SelectLimitAfterOffsetStep<R extends Record>
interface
SelectLimitPercentAfterOffsetStep<R extends Record>
interface
SelectLimitPercentStep<R extends Record>
interface
SelectLimitStep<R extends Record>
interface
SelectOffsetStep<R extends Record>
interface
SelectOnConditionStep<R extends Record>
interface
SelectOptionalOnStep<R extends Record>
interface
SelectOptionStep<R extends Record>
interface
SelectOrderByStep<R extends Record>
interface
SelectQualifyConditionStep<R extends Record>
interface
SelectQualifyStep<R extends Record>
interface
SelectQuery<R extends Record>
ASELECT
statement (model API).interface
SelectSeekLimitStep<R extends Record>
interface
SelectSeekStep1<R extends Record,
T1> interface
SelectSeekStep10<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> interface
SelectSeekStep11<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> interface
SelectSeekStep12<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> interface
SelectSeekStep13<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> interface
SelectSeekStep14<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> interface
SelectSeekStep15<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> interface
SelectSeekStep16<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> interface
SelectSeekStep17<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> interface
SelectSeekStep18<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> interface
SelectSeekStep19<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> interface
SelectSeekStep2<R extends Record,
T1, T2> interface
SelectSeekStep20<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> interface
SelectSeekStep21<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> interface
SelectSeekStep22<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> interface
SelectSeekStep3<R extends Record,
T1, T2, T3> interface
SelectSeekStep4<R extends Record,
T1, T2, T3, T4> interface
SelectSeekStep5<R extends Record,
T1, T2, T3, T4, T5> interface
SelectSeekStep6<R extends Record,
T1, T2, T3, T4, T5, T6> interface
SelectSeekStep7<R extends Record,
T1, T2, T3, T4, T5, T6, T7> interface
SelectSeekStep8<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8> interface
SelectSeekStep9<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9> interface
SelectSeekStepN<R extends Record>
interface
SelectSelectStep<R extends Record>
interface
SelectStartWithStep<R extends Record>
interface
SelectUnionStep<R extends Record>
interface
SelectWhereStep<R extends Record>
interface
SelectWindowStep<R extends Record>
interface
SelectWithTiesAfterOffsetStep<R extends Record>
interface
SelectWithTiesStep<R extends Record>
interface
A table.interface
TableOnConditionStep<R extends Record>
An intermediate (optional) type for the construction of aJOIN
clause, where the join criteria is added using anON
clause (with aCondition
.interface
TableOptionalOnStep<R extends Record>
interface
A step in the construction of anXMLTABLE
expression.interface
A step in the construction of anXMLTABLE
expression.Modifier and TypeMethodDescriptionvoid
Add tables to the table product.void
Add tables to the table product.void
Add tables to the table product.void
Add tables to the table product.void
Joins the existing table product to a new table using a condition, connecting them with each other withOperator.AND
.void
Joins the existing table product to a new table using a condition, connecting them with each other withOperator.AND
.void
Joins the existing table product to a new table using a condition, connecting them with each other withOperator.AND
.void
Joins the existing table product to a new table using a condition, connecting them with each other withOperator.AND
.void
SelectQuery.addJoin
(TableLike<?> table, JoinType type, Condition[] conditions, Field<?>[] partitionBy) Joins the existing table product to a new table using conditions, connecting them with each other withOperator.AND
.void
SelectQuery.addJoin
(TableLike<?> table, JoinType type, Condition conditions, Field<?>[] partitionBy) Joins the existing table product to a new table using conditions, connecting them with each other withOperator.AND
.void
SelectQuery.addJoin
(TableLike<?> table, JoinType type, QOM.JoinHint hint, Condition condition) Joins the existing table product to a new table using a condition, connecting them with each other withOperator.AND
.void
SelectQuery.addJoin
(TableLike<?> table, JoinType type, QOM.JoinHint hint, Condition... conditions) Joins the existing table product to a new table using a condition, connecting them with each other withOperator.AND
.void
SelectQuery.addJoin
(TableLike<?> table, JoinType type, QOM.JoinHint hint, Condition[] conditions, Field<?>[] partitionBy) Joins the existing table product to a new table using conditions, connecting them with each other withOperator.AND
.void
SelectQuery.addJoin
(TableLike<?> table, JoinType type, QOM.JoinHint hint, Condition conditions, Field<?>[] partitionBy) Joins the existing table product to a new table using conditions, connecting them with each other withOperator.AND
.void
SelectQuery.addJoinOnKey
(TableLike<?> table, JoinType type) Joins the existing table product to a new table using a foreign key.void
SelectQuery.addJoinOnKey
(TableLike<?> table, JoinType type, ForeignKey<?, ?> key) Joins the existing table product to a new table using a foreign key.void
SelectQuery.addJoinOnKey
(TableLike<?> table, JoinType type, QOM.JoinHint hint) Joins the existing table product to a new table using a foreign key.void
SelectQuery.addJoinOnKey
(TableLike<?> table, JoinType type, QOM.JoinHint hint, ForeignKey<?, ?> key) Joins the existing table product to a new table using a foreign key.void
SelectQuery.addJoinOnKey
(TableLike<?> table, JoinType type, QOM.JoinHint hint, TableField<?, ?>... keyFields) Joins the existing table product to a new table using a foreign key.void
SelectQuery.addJoinOnKey
(TableLike<?> table, JoinType type, TableField<?, ?>... keyFields) Joins the existing table product to a new table using a foreign key.void
SelectQuery.addJoinUsing
(TableLike<?> table, Collection<? extends Field<?>> fields) Joins the existing table product to a new table with aUSING
clause.void
SelectQuery.addJoinUsing
(TableLike<?> table, JoinType type, Collection<? extends Field<?>> fields) Joins the existing table product to a new table with aUSING
clause.void
SelectQuery.addJoinUsing
(TableLike<?> table, JoinType type, QOM.JoinHint hint, Collection<? extends Field<?>> fields) Joins the existing table product to a new table with aUSING
clause.void
Add tables to theUSING
clause.void
Add tables to theUSING
clause.@NotNull SelectJoinStep
<R> SelectJoinStep.crossApply
(TableLike<?> table) CROSS APPLY
a table to this table.Table.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(TableLike)
CROSS JOIN
a table to this table.@NotNull SelectJoinStep
<R> Add aFROM
clause to the query.@NotNull SelectJoinStep
<R> Add aFROM
clause to the query.@NotNull UpdateWhereStep
<R> Add aFROM
clause to the query.@NotNull UpdateWhereStep
<R> Add aFROM
clause to the query.@NotNull SelectOnStep
<R> SelectJoinStep.fullHashJoin
(TableLike<?> table) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterHashJoin(TableLike)
.@NotNull TablePartitionByStep
<Record> Table.fullHashJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull SelectOnStep
<R> Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterJoin(TableLike)
.@NotNull TablePartitionByStep
<Record> FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep
<Record> FULL OUTER JOIN
a table to this table.@NotNull SelectOnStep
<R> SelectJoinStep.fullLoopJoin
(TableLike<?> table) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterLoopJoin(TableLike)
.@NotNull TablePartitionByStep
<Record> Table.fullLoopJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull SelectOnStep
<R> SelectJoinStep.fullMergeJoin
(TableLike<?> table) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterMergeJoin(TableLike)
.@NotNull TablePartitionByStep
<Record> Table.fullMergeJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.@NotNull SelectOnStep
<R> SelectJoinStep.fullOuterHashJoin
(TableLike<?> table) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterHashJoin(TableLike)
@NotNull TablePartitionByStep
<Record> Table.fullOuterHashJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull SelectOnStep
<R> SelectJoinStep.fullOuterJoin
(TableLike<?> table) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterJoin(TableLike)
@NotNull TablePartitionByStep
<Record> Table.fullOuterJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep
<Record> TableOuterJoinStep.fullOuterJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table.@NotNull SelectOnStep
<R> SelectJoinStep.fullOuterLoopJoin
(TableLike<?> table) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterLoopJoin(TableLike)
@NotNull TablePartitionByStep
<Record> Table.fullOuterLoopJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull SelectOnStep
<R> SelectJoinStep.fullOuterMergeJoin
(TableLike<?> table) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterMergeJoin(TableLike)
@NotNull TablePartitionByStep
<Record> Table.fullOuterMergeJoin
(TableLike<?> table) FULL OUTER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.@NotNull SelectOnStep
<R> Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.hashJoin(TableLike)
.@NotNull TableOnStep
<Record> INNER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull SelectOnStep
<R> SelectJoinStep.innerHashJoin
(TableLike<?> table) Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.innerHashJoin(TableLike)
.@NotNull TableOnStep
<Record> Table.innerHashJoin
(TableLike<?> table) INNER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull SelectOnStep
<R> Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(TableLike)
.@NotNull TableOnStep
<Record> INNER JOIN
a table to this table.@NotNull SelectOnStep
<R> SelectJoinStep.innerLoopJoin
(TableLike<?> table) Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.innerLoopJoin(TableLike)
.@NotNull TableOnStep
<Record> Table.innerLoopJoin
(TableLike<?> table) INNER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull SelectOnStep
<R> SelectJoinStep.innerMergeJoin
(TableLike<?> table) Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.innerMergeJoin(TableLike)
.@NotNull TableOnStep
<Record> Table.innerMergeJoin
(TableLike<?> table) INNER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.@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 SelectOptionalOnStep
<R> SelectJoinStep.join
(TableLike<?> table, JoinType type, QOM.JoinHint hint) Convenience method to join a table to the last table added to theFROM
clause usingTable.join(TableLike, JoinType, JoinHint)
@NotNull TableOnStep
<Record> INNER JOIN
a table to this table.@NotNull TableOptionalOnStep
<Record> Join a table to this table using aJoinType
.@NotNull TableOptionalOnStep
<Record> Table.join
(TableLike<?> table, JoinType type, QOM.JoinHint hint) Join a table to this table using aJoinType
andQOM.JoinHint
.@NotNull TablePartitionByStep
<Record> Join a table to this table using aJoinType
.@NotNull TablePartitionByStep
<Record> TableOuterJoinStep.join
(TableLike<?> table, JoinType type, QOM.JoinHint hint) Join a table to this table using aJoinType
and aQOM.JoinHint
.@NotNull SelectOnStep
<R> SelectJoinStep.leftAntiJoin
(TableLike<?> table) A syntheticLEFT ANTI JOIN
clause that translates to an equivalentNOT EXISTS
predicate.@NotNull TableOnStep
<R> Table.leftAntiJoin
(TableLike<?> table) A syntheticLEFT ANTI JOIN
clause that translates to an equivalentNOT EXISTS
predicate.@NotNull SelectJoinPartitionByStep
<R> SelectJoinStep.leftHashJoin
(TableLike<?> table) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterHashJoin(TableLike)
.@NotNull TablePartitionByStep
<Record> Table.leftHashJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull SelectJoinPartitionByStep
<R> Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(TableLike)
.@NotNull TablePartitionByStep
<Record> LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep
<Record> LEFT OUTER JOIN
a table to this table.@NotNull SelectJoinPartitionByStep
<R> SelectJoinStep.leftLoopJoin
(TableLike<?> table) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterLoopJoin(TableLike)
.@NotNull TablePartitionByStep
<Record> Table.leftLoopJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull SelectJoinPartitionByStep
<R> SelectJoinStep.leftMergeJoin
(TableLike<?> table) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterMergeJoin(TableLike)
.@NotNull TablePartitionByStep
<Record> Table.leftMergeJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.@NotNull SelectJoinPartitionByStep
<R> SelectJoinStep.leftOuterHashJoin
(TableLike<?> table) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterHashJoin(TableLike)
@NotNull TablePartitionByStep
<Record> Table.leftOuterHashJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull SelectJoinPartitionByStep
<R> SelectJoinStep.leftOuterJoin
(TableLike<?> table) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(TableLike)
@NotNull TablePartitionByStep
<Record> Table.leftOuterJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep
<Record> TableOuterJoinStep.leftOuterJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table.@NotNull SelectJoinPartitionByStep
<R> SelectJoinStep.leftOuterLoopJoin
(TableLike<?> table) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterLoopJoin(TableLike)
@NotNull TablePartitionByStep
<Record> Table.leftOuterLoopJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull SelectJoinPartitionByStep
<R> SelectJoinStep.leftOuterMergeJoin
(TableLike<?> table) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterMergeJoin(TableLike)
@NotNull TablePartitionByStep
<Record> Table.leftOuterMergeJoin
(TableLike<?> table) LEFT OUTER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.@NotNull SelectOnStep
<R> SelectJoinStep.leftSemiJoin
(TableLike<?> table) A syntheticLEFT SEMI JOIN
clause that translates to an equivalentEXISTS
predicate.@NotNull TableOnStep
<R> Table.leftSemiJoin
(TableLike<?> table) A syntheticLEFT SEMI JOIN
clause that translates to an equivalentEXISTS
predicate.@NotNull SelectOnStep
<R> Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.loopJoin(TableLike)
.@NotNull TableOnStep
<Record> INNER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull SelectOnStep
<R> Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.mergeJoin(TableLike)
.@NotNull TableOnStep
<Record> INNER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.@NotNull SelectJoinStep
<R> SelectJoinStep.naturalFullOuterJoin
(TableLike<?> table) Convenience method toNATURAL FULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalFullOuterJoin(TableLike)
Table.naturalFullOuterJoin
(TableLike<?> table) NATURAL FULL OUTER JOIN
a table to this table.@NotNull SelectJoinStep
<R> SelectJoinStep.naturalJoin
(TableLike<?> table) Convenience method toNATURAL JOIN
a table to the last table added to theFROM
clause usingTable.naturalJoin(TableLike)
Table.naturalJoin
(TableLike<?> table) NATURAL JOIN
a table to this table.@NotNull SelectJoinStep
<R> SelectJoinStep.naturalLeftOuterJoin
(TableLike<?> table) Convenience method toNATURAL LEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalLeftOuterJoin(TableLike)
Table.naturalLeftOuterJoin
(TableLike<?> table) NATURAL LEFT OUTER JOIN
a table to this table.@NotNull SelectJoinStep
<R> SelectJoinStep.naturalRightOuterJoin
(TableLike<?> table) Convenience method toNATURAL RIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalRightOuterJoin(TableLike)
Table.naturalRightOuterJoin
(TableLike<?> table) NATURAL RIGHT OUTER JOIN
a table to this table.@NotNull SelectJoinStep
<R> SelectJoinStep.outerApply
(TableLike<?> table) OUTER APPLY
a table to this table.Table.outerApply
(TableLike<?> table) OUTER APPLY
a table to this table.@NotNull SelectJoinPartitionByStep
<R> SelectJoinStep.rightHashJoin
(TableLike<?> table) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterHashJoin(TableLike)
.@NotNull TablePartitionByStep
<Record> Table.rightHashJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull SelectJoinPartitionByStep
<R> Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(TableLike)
.@NotNull TablePartitionByStep
<Record> RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep
<Record> RIGHT OUTER JOIN
a table to this table.@NotNull SelectJoinPartitionByStep
<R> SelectJoinStep.rightLoopJoin
(TableLike<?> table) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterLoopJoin(TableLike)
.@NotNull TablePartitionByStep
<Record> Table.rightLoopJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull SelectJoinPartitionByStep
<R> SelectJoinStep.rightMergeJoin
(TableLike<?> table) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterMergeJoin(TableLike)
.@NotNull TablePartitionByStep
<Record> Table.rightMergeJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.@NotNull SelectJoinPartitionByStep
<R> SelectJoinStep.rightOuterHashJoin
(TableLike<?> table) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterHashJoin(TableLike)
@NotNull TablePartitionByStep
<Record> Table.rightOuterHashJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table with aQOM.JoinHint.HASH
hint.@NotNull SelectJoinPartitionByStep
<R> SelectJoinStep.rightOuterJoin
(TableLike<?> table) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(TableLike)
@NotNull TablePartitionByStep
<Record> Table.rightOuterJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep
<Record> TableOuterJoinStep.rightOuterJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table.@NotNull SelectJoinPartitionByStep
<R> SelectJoinStep.rightOuterLoopJoin
(TableLike<?> table) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterLoopJoin(TableLike)
@NotNull TablePartitionByStep
<Record> Table.rightOuterLoopJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table with aQOM.JoinHint.LOOP
hint.@NotNull SelectJoinPartitionByStep
<R> SelectJoinStep.rightOuterMergeJoin
(TableLike<?> table) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterMergeJoin(TableLike)
@NotNull TablePartitionByStep
<Record> Table.rightOuterMergeJoin
(TableLike<?> table) RIGHT OUTER JOIN
a table to this table with aQOM.JoinHint.MERGE
hint.<R extends Record>
@NotNull SelectWhereStep<R> DSLContext.selectFrom
(TableLike<R> table) Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
@NotNull SelectWhereStep<R> WithStep.selectFrom
(TableLike<R> table) Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
@NotNull SelectQuery<R> DSLContext.selectQuery
(TableLike<R> table) Create a newSelectQuery
@NotNull SelectOnStep
<R> SelectJoinStep.straightJoin
(TableLike<?> table) STRAIGHT_JOIN
a table to this table.@NotNull TableOnStep
<Record> Table.straightJoin
(TableLike<?> table) STRAIGHT_JOIN
a table to this table.@NotNull DeleteWhereStep
<R> Add aUSING
clause to the query.@NotNull DeleteWhereStep
<R> Add aUSING
clause to the query.@NotNull MergeOnStep
<R> Add theUSING
clause to the SQL standardMERGE
statement.Modifier and TypeMethodDescriptionvoid
SelectQuery.addFrom
(Collection<? extends TableLike<?>> from) Add tables to the table product.void
UpdateQuery.addFrom
(Collection<? extends TableLike<?>> from) Add tables to the table product.void
DeleteQuery.addUsing
(Collection<? extends TableLike<?>> tables) Add tables to theUSING
clause.@NotNull SelectJoinStep
<R> SelectFromStep.from
(Collection<? extends TableLike<?>> tables) Add aFROM
clause to the query.@NotNull UpdateWhereStep
<R> UpdateFromStep.from
(Collection<? extends TableLike<?>> tables) Add aFROM
clause to the query.@NotNull DeleteWhereStep
<R> DeleteUsingStep.using
(Collection<? extends TableLike<?>> tables) Add aUSING
clause to the query. -
Uses of TableLike in org.jooq.impl
Modifier and TypeInterfaceDescriptionstatic interface
QOM.CrossApply<R extends Record>
static interface
QOM.CrossJoin<R extends Record>
static interface
QOM.DataChangeDeltaTable<R extends Record>
static interface
QOM.DerivedTable<R extends Record>
static interface
static interface
QOM.FullJoin<R extends Record>
static interface
static interface
QOM.HintedTable<R extends Record>
A table with a MySQL style index access hint.static interface
static interface
QOM.JoinTable<R extends Record,
J extends QOM.JoinTable<R, J>> static interface
QOM.Lateral<R extends Record>
static interface
QOM.LeftAntiJoin<R extends Record>
static interface
QOM.LeftJoin<R extends Record>
static interface
QOM.LeftSemiJoin<R extends Record>
static interface
QOM.LinkedTable<R extends Record>
A table with a database link.static interface
QOM.NaturalFullJoin<R extends Record>
static interface
QOM.NaturalJoin<R extends Record>
static interface
QOM.NaturalLeftJoin<R extends Record>
static interface
QOM.NaturalRightJoin<R extends Record>
static interface
QOM.OuterApply<R extends Record>
static interface
QOM.QualifiedJoin<R extends Record,
J extends QOM.QualifiedJoin<R, J>> static interface
QOM.RightJoin<R extends Record>
static interface
static interface
QOM.StraightJoin<R extends Record>
static interface
QOM.TableAlias<R extends Record>
static interface
QOM.Values<R extends Record>
static interface
QOM.WithOrdinalityTable<R extends Record>
A collection derived table or table valued function with aWITH ORDINALITY
clause.static interface
QOM.WithTable<R extends Record>
A table with a T-SQL styleWITH
hint.Modifier and TypeClassDescriptionclass
CustomTable<R extends TableRecord<R>>
A base class for customTable
implementations in client code.class
A common base type for tablesModifier and TypeMethodDescriptionfinal TableOptionalOnStep
<Record> final TableOptionalOnStep
<Record> TableImpl.join
(TableLike<?> table, JoinType type, QOM.JoinHint hint) Create aLATERAL
joined table.Get theMULTISET
operator to nest subqueries.<R extends Record>
SelectWhereStep<R> DefaultDSLContext.selectFrom
(TableLike<R> table) static <R extends Record>
@NotNull SelectWhereStep<R> DSL.selectFrom
(TableLike<R> table) Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
SelectQuery<R> DefaultDSLContext.selectQuery
(TableLike<R> table)