Uses of Interface
org.jooq.TableLike

Packages that use TableLike

Package	Description
org.jooq	The org.jooq package contains jOOQ's public API.
org.jooq.impl	The org.jooq.impl package contains jOOQ's implementation classes.

Uses of TableLike in org.jooq

Subinterfaces of TableLike in org.jooq

Modifier and Type	Interface and Description
interface	CommonTableExpression<R extends Record> A common table expression is a table that can be supplied to WITH clauses.
interface	Select<R extends Record> A Query that can provide a Result after execution
interface	SelectConditionStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectConnectByAfterStartWithConditionStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectConnectByConditionStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectConnectByStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectDistinctOnStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectFinalStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForUpdateOfStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForUpdateStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForUpdateWaitStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectFromStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectGroupByStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectHavingConditionStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectHavingStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectIntoStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectJoinStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectLimitAfterOffsetStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectLimitPercentAfterOffsetStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectLimitPercentStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectLimitStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectOffsetStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectOnConditionStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectOptionalOnStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectOptionStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectOrderByStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectQuery<R extends Record> A query for data selection
interface	SelectSeekLimitStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep1<R extends Record,T1> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep2<R extends Record,T1,T2> This type is used for the Select's DSL API when selecting generic Record types.
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> This type is used for the Select's DSL API when selecting generic Record types.
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> This type is used for the Select's DSL API when selecting generic Record types.
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> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep3<R extends Record,T1,T2,T3> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep4<R extends Record,T1,T2,T3,T4> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep5<R extends Record,T1,T2,T3,T4,T5> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep6<R extends Record,T1,T2,T3,T4,T5,T6> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStepN<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSelectStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectStartWithStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectUnionStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectWhereStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectWindowStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectWithTiesAfterOffsetStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectWithTiesStep<R extends Record> This type is used for the Select's DSL API when selecting generic Record types.
interface	Table<R extends Record> A table to be used in queries
interface	TableOnConditionStep<R extends Record> An intermediate (optional) type for the construction of a JOIN clause, where the join criteria is added using an ON clause (with a Condition.
interface	TableOptionalOnStep<R extends Record> An intermediate type for the construction of a JOIN clause, where there may optionally be a join criteria added using an ON clause (with a Condition), or using a USING clause (with a list of Field) 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.

Methods in org.jooq with parameters of type TableLike

Modifier and Type	Method and Description
void	UpdateQuery.addFrom(TableLike<?>... from) Add tables to the table product.
void	SelectQuery.addFrom(TableLike<?>... from) Add tables to the table product.
void	UpdateQuery.addFrom(TableLike<?> from) Add tables to the table product.
void	SelectQuery.addFrom(TableLike<?> from) Add tables to the table product.
void	SelectQuery.addJoin(TableLike<?> table, Condition... conditions) Joins the existing table product to a new table using a condition, connecting them with each other with Operator.AND.
void	SelectQuery.addJoin(TableLike<?> table, Condition condition) Joins the existing table product to a new table using a condition, connecting them with each other with Operator.AND.
void	SelectQuery.addJoin(TableLike<?> table, JoinType type, Condition... conditions) Joins the existing table product to a new table using a condition, connecting them with each other with Operator.AND.
void	SelectQuery.addJoin(TableLike<?> table, JoinType type, Condition condition) Joins the existing table product to a new table using a condition, connecting them with each other with Operator.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 with Operator.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 with Operator.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, 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 a USING clause.
void	SelectQuery.addJoinUsing(TableLike<?> table, JoinType type, Collection<? extends Field<?>> fields) Joins the existing table product to a new table with a USING clause.
Table<Record>	Table.crossApply(TableLike<?> table) CROSS APPLY a table to this table.
SelectJoinStep<R>	SelectJoinStep.crossApply(TableLike<?> table) CROSS APPLY a table to this table.
Table<Record>	Table.crossJoin(TableLike<?> table) CROSS JOIN a table to this table.
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.
UpdateWhereStep<R>	UpdateFromStep.from(TableLike<?>... table) Add a FROM clause to the query.
SelectJoinStep<R>	SelectFromStep.from(TableLike<?>... tables) Add a FROM clause to the query.
UpdateWhereStep<R>	UpdateFromStep.from(TableLike<?> table) Add a FROM clause to the query.
SelectJoinStep<R>	SelectFromStep.from(TableLike<?> table) Add a FROM clause to the query.
TableOnStep<Record>	Table.fullJoin(TableLike<?> table) FULL OUTER JOIN a table to this table.
SelectOnStep<R>	SelectJoinStep.fullJoin(TableLike<?> table) Convenience method to FULL OUTER JOIN a table to the last table added to the FROM clause using Table.fullOuterJoin(TableLike).
TableOnStep<Record>	Table.fullOuterJoin(TableLike<?> table) FULL OUTER JOIN a table to this table.
SelectOnStep<R>	SelectJoinStep.fullOuterJoin(TableLike<?> table) Convenience method to FULL OUTER JOIN a table to the last table added to the FROM clause using Table.fullOuterJoin(TableLike) This is only possible where the underlying RDBMS supports it
TableOnStep<Record>	Table.innerJoin(TableLike<?> table) INNER JOIN a table to this table.
SelectOnStep<R>	SelectJoinStep.innerJoin(TableLike<?> table) Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(TableLike).
TableOnStep<Record>	Table.join(TableLike<?> table) INNER JOIN a table to this table.
SelectOnStep<R>	SelectJoinStep.join(TableLike<?> table) Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(TableLike).
TableOnStep<Record>	TableOuterJoinStep.join(TableLike<?> table, JoinType type) Join a table to this table using a JoinType.
TableOptionalOnStep<Record>	Table.join(TableLike<?> table, JoinType type) Join a table to this table using a JoinType Depending on the JoinType, a subsequent TableOnStep.on(Condition) or TableOnStep.using(Field...) clause is required.
SelectOptionalOnStep<R>	SelectJoinStep.join(TableLike<?> table, JoinType type) Convenience method to join a table to the last table added to the FROM clause using Table.join(TableLike, JoinType) Depending on the JoinType, a subsequent SelectOnStep.on(Condition) or SelectOnStep.using(Field...) clause is required.
TableOnStep<R>	Table.leftAntiJoin(TableLike<?> table) A synthetic LEFT ANTI JOIN clause that translates to an equivalent NOT EXISTS predicate.
SelectOnStep<R>	SelectJoinStep.leftAntiJoin(TableLike<?> table) A synthetic LEFT ANTI JOIN clause that translates to an equivalent NOT EXISTS predicate.
TableOnStep<Record>	TableOuterJoinStep.leftJoin(TableLike<?> table) LEFT OUTER JOIN a table to this table.
TablePartitionByStep<Record>	Table.leftJoin(TableLike<?> table) LEFT OUTER JOIN a table to this table.
SelectJoinPartitionByStep<R>	SelectJoinStep.leftJoin(TableLike<?> table) Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.leftOuterJoin(TableLike).
TableOnStep<Record>	TableOuterJoinStep.leftOuterJoin(TableLike<?> table) LEFT OUTER JOIN a table to this table.
TablePartitionByStep<Record>	Table.leftOuterJoin(TableLike<?> table) LEFT OUTER JOIN a table to this table.
SelectJoinPartitionByStep<R>	SelectJoinStep.leftOuterJoin(TableLike<?> table) Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.leftOuterJoin(TableLike)
TableOnStep<R>	Table.leftSemiJoin(TableLike<?> table) A synthetic LEFT SEMI JOIN clause that translates to an equivalent EXISTS predicate.
SelectOnStep<R>	SelectJoinStep.leftSemiJoin(TableLike<?> table) A synthetic LEFT SEMI JOIN clause that translates to an equivalent EXISTS predicate.
Table<Record>	Table.naturalJoin(TableLike<?> table) NATURAL JOIN a table to this table.
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.
Table<Record>	Table.naturalLeftOuterJoin(TableLike<?> table) NATURAL LEFT OUTER JOIN a table to this table.
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.
Table<Record>	Table.naturalRightOuterJoin(TableLike<?> table) NATURAL RIGHT OUTER JOIN a table to this table.
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.
Table<Record>	Table.outerApply(TableLike<?> table) OUTER APPLY a table to this table.
SelectJoinStep<R>	SelectJoinStep.outerApply(TableLike<?> table) OUTER APPLY a table to this table.
TableOnStep<Record>	TableOuterJoinStep.rightJoin(TableLike<?> table) RIGHT OUTER JOIN a table to this table.
TablePartitionByStep<Record>	Table.rightJoin(TableLike<?> table) RIGHT OUTER JOIN a table to this table.
SelectJoinPartitionByStep<R>	SelectJoinStep.rightJoin(TableLike<?> table) Convenience method to RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table.rightOuterJoin(TableLike).
TableOnStep<Record>	TableOuterJoinStep.rightOuterJoin(TableLike<?> table) RIGHT OUTER JOIN a table to this table.
TablePartitionByStep<Record>	Table.rightOuterJoin(TableLike<?> table) RIGHT OUTER JOIN a table to this table.
SelectJoinPartitionByStep<R>	SelectJoinStep.rightOuterJoin(TableLike<?> table) Convenience method to RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table.rightOuterJoin(TableLike) This is only possible where the underlying RDBMS supports it
<R extends Record> SelectQuery<R>	DSLContext.selectQuery(TableLike<R> table) Create a new SelectQuery
TableOnStep<Record>	Table.straightJoin(TableLike<?> table) STRAIGHT_JOIN a table to this table.
SelectOnStep<R>	SelectJoinStep.straightJoin(TableLike<?> table) STRAIGHT_JOIN a table to this table.
MergeOnStep<R>	MergeUsingStep.using(TableLike<?> table) Add the USING clause to the SQL standard MERGE statement

Method parameters in org.jooq with type arguments of type TableLike

Modifier and Type	Method and Description
void	UpdateQuery.addFrom(Collection<? extends TableLike<?>> from) Add tables to the table product.
void	SelectQuery.addFrom(Collection<? extends TableLike<?>> from) Add tables to the table product.
UpdateWhereStep<R>	UpdateFromStep.from(Collection<? extends TableLike<?>> tables) Add a FROM clause to the query.
SelectJoinStep<R>	SelectFromStep.from(Collection<? extends TableLike<?>> tables) Add a FROM clause to the query.

Uses of TableLike in org.jooq.impl

Classes in org.jooq.impl that implement TableLike

Modifier and Type	Class and Description
class	CustomTable<R extends TableRecord<R>> A base class for custom Table implementations in client code.
class	TableImpl<R extends Record> A common base type for tables This type is for JOOQ INTERNAL USE only.

Methods in org.jooq.impl with parameters of type TableLike

Modifier and Type	Method and Description
static <R extends Record> Table<R>	DSL.lateral(TableLike<R> table) Create a LATERAL joined table.
<R extends Record> SelectQuery<R>	DefaultDSLContext.selectQuery(TableLike<R> table)