java.lang.Object
- org.jooq.impl.TableImpl<R>

All Implemented Interfaces:

Serializable, Named, Qualified, QueryPart, QueryPartInternal, Table<R>, TableLike<R>

Direct Known Subclasses:

CustomTable
```
@Internal
public class TableImpl<R extends Record>
extends Object
```
A common base type for tables
This type is for JOOQ INTERNAL USE only. Do not reference directly

Author:

Lukas Eder

See Also:

Serialized Form

Field Summary

Fields
Modifier and Type Field Description

protected Field<?>[] parameters

Constructor Summary

Constructors
Constructor	Description
`TableImpl(String name)`	Deprecated. - 3.10 - [#5996] - Use `TableImpl(Name)` instead (or re-generated your code).
`TableImpl(String name, Schema schema)`	Deprecated. - 3.10 - [#5996] - Use `TableImpl(Name, Schema)` instead (or re-generated your code).
`TableImpl(String name, Schema schema, Table<R> aliased)`	Deprecated. - 3.10 - [#5996] - Use `TableImpl(Name, Schema, Table)` instead (or re-generated your code).
`TableImpl(String name, Schema schema, Table<R> aliased, Field<?>[] parameters)`	Deprecated. - 3.10 - [#5996] - Use `TableImpl(Name, Schema, Table, Field[])` instead (or re-generated your code).
`TableImpl(String name, Schema schema, Table<R> aliased, Field<?>[] parameters, String comment)`	Deprecated. - 3.10 - [#5996] - Use `TableImpl(Name, Schema, Table, Field[], String)` instead (or re-generated your code).
`TableImpl(Name name)`
`TableImpl(Name name, Schema schema)`
`TableImpl(Name name, Schema schema, Table<?> child, ForeignKey<?,R> path, Table<R> aliased, Field<?>[] parameters, Comment comment)`
`TableImpl(Name name, Schema schema, Table<?> child, ForeignKey<?,R> path, Table<R> aliased, Field<?>[] parameters, Comment comment, TableOptions options)`
`TableImpl(Name name, Schema schema, Table<R> aliased)`
`TableImpl(Name name, Schema schema, Table<R> aliased, Field<?>[] parameters)`
`TableImpl(Name name, Schema schema, Table<R> aliased, Field<?>[] parameters, String comment)`	Deprecated. - 3.11 - [#7027] - Use `TableImpl(Name, Schema, Table, Field[], Comment)` instead.
`TableImpl(Name name, Schema schema, Table<R> aliased, Field<?>[] parameters, Comment comment)`
`TableImpl(Name name, Schema schema, Table<R> aliased, Field<?>[] parameters, Comment comment, TableOptions options)`
`TableImpl(Table<?> child, ForeignKey<?,R> path, Table<R> parent)`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods Deprecated Methods
Modifier and Type	Method	Description
`void`	`accept(Context<?> ctx)`	This `QueryPart` can `accept` a `Context` object in order to render a SQL string or to bind its variables.
`protected boolean`	`aliased()`	Check if this table already aliases another one.
`Table<R>`	`as(String alias)`	Create an alias for this table.
`Table<R>`	`as(String alias, String... fieldAliases)`	Create an alias for this table and its fields.
`Table<R>`	`as(String alias, BiFunction<? super Field<?>,? super Integer,? extends String> aliasFunction)`	Create an alias for this table and its fields.
`Table<R>`	`as(String alias, Function<? super Field<?>,? extends String> aliasFunction)`	Create an alias for this table and its fields.
`Table<R>`	`as(Name as)`	Subclasses may override this method to provide custom aliasing implementations
`Table<R>`	`as(Name alias, BiFunction<? super Field<?>,? super Integer,? extends Name> aliasFunction)`	Create an alias for this table and its fields.
`Table<R>`	`as(Name alias, Function<? super Field<?>,? extends Name> aliasFunction)`	Create an alias for this table and its fields.
`Table<R>`	`as(Name as, Name... fieldAliases)`	Subclasses may override this method to provide custom aliasing implementations
`Table<R>`	`as(Table<?> otherTable)`	Create an alias for this table based on another table's name.
`Table<R>`	`as(Table<?> otherTable, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> aliasFunction)`	Create an alias for this table and its fields.
`Table<R>`	`as(Table<?> otherTable, Function<? super Field<?>,? extends Field<?>> aliasFunction)`	Create an alias for this table and its fields.
`Table<R>`	`as(Table<?> otherTable, Field<?>... otherFields)`	Create an alias for this table based on another table's name.
`Table<R>`	`asOfScn(Number scn)`	Create an `SQLDialect.ORACLE` flashback query clause from this table.
`Table<R>`	`asOfScn(Field<? extends Number> scn)`	Create an `SQLDialect.ORACLE` flashback query clause from this table.
`Table<R>`	`asOfTimestamp(Timestamp timestamp)`	Create an `SQLDialect.ORACLE` flashback query clause from this table.
`Table<R>`	`asOfTimestamp(Field<Timestamp> timestamp)`	Create an `SQLDialect.ORACLE` flashback query clause from this table.
`Table<R>`	`asTable()`	The underlying table representation of this object.
`Table<R>`	`asTable(String alias)`	The underlying aliased table representation of this object.
`Table<R>`	`asTable(String alias, String... fieldAliases)`	The underlying aliased table representation of this object.
`Table<R>`	`asTable(String alias, BiFunction<? super Field<?>,? super Integer,? extends String> aliasFunction)`	The underlying aliased table representation of this object.
`Table<R>`	`asTable(String alias, Function<? super Field<?>,? extends String> aliasFunction)`	The underlying aliased table representation of this object.
`Table<R>`	`asTable(Name alias)`	The underlying aliased table representation of this object.
`Table<R>`	`asTable(Name alias, Name... fieldAliases)`	The underlying aliased table representation of this object.
`Table<R>`	`asTable(Table<?> alias)`	The underlying aliased table representation of this object.
`Table<R>`	`asTable(Table<?> alias, Field<?>... fieldAliases)`	The underlying aliased table representation of this object.
`QualifiedAsterisk`	`asterisk()`	Create a qualified asterisk expression from this table (`table.*`) for use with `SELECT`.
`Table<R>`	`at(String link)`	A table reference of this table at a given `Link`.
`Table<R>`	`at(Link link)`	A table reference of this table at a given `Link`.
`Table<R>`	`at(Name link)`	A table reference of this table at a given `Link`.
`void`	`bind(BindContext context)`	Deprecated. - 3.4.0 - [#2694] - Use `QueryPartInternal.accept(Context)` instead.
`Clause[]`	`clauses(Context<?> ctx)`	The `Clause`s that are represented by this query part.
`protected DSLContext`	`create()`	Deprecated. - 3.11.0 - [#6722] - Use `Attachable.configuration()` and `Configuration.dsl()` instead.
`protected DSLContext`	`create(Configuration configuration)`	Deprecated. - 3.11.0 - [#6722] - Use `Attachable.configuration()` and `Configuration.dsl()` instead.
`protected DSLContext`	`create(Context<?> ctx)`	Deprecated. - 3.11.0 - [#6722] - Use `Attachable.configuration()` and `Configuration.dsl()` instead.
`protected <T> TableField<R,T>`	`createField(String name, DataType<T> type)`	Deprecated. - 3.12.0 - [#8000] - Use `createField(Name, DataType)` instead.
`protected <T> TableField<R,T>`	`createField(String name, DataType<T> type, String comment)`	Deprecated. - 3.12.0 - [#8000] - Use `createField(Name, DataType, String)` instead.
`protected <T,U> TableField<R,U>`	`createField(String name, DataType<T> type, String comment, Binding<T,U> binding)`	Deprecated. - 3.12.0 - [#8000] - Use `createField(Name, DataType, String, Binding)` instead.
`protected <T,U> TableField<R,U>`	`createField(String name, DataType<T> type, String comment, Converter<T,U> converter)`	Deprecated. - 3.12.0 - [#8000] - Use `createField(Name, DataType, String, Converter)` instead.
`protected <T,X,U> TableField<R,U>`	`createField(String name, DataType<T> type, String comment, Converter<X,U> converter, Binding<T,X> binding)`	Deprecated. - 3.12.0 - [#8000] - Use `createField(Name, DataType, String, Converter, Binding)` instead.
`protected static <R extends Record,T> TableField<R,T>`	`createField(String name, DataType<T> type, Table<R> table)`	Deprecated. - 3.12.0 - [#8000] - Use `AbstractTable.createField(Name, DataType, Table)` instead.
`protected static <R extends Record,T> TableField<R,T>`	`createField(String name, DataType<T> type, Table<R> table, String comment)`	Deprecated. - 3.12.0 - [#8000] - Use `AbstractTable.createField(Name, DataType, Table, String)` instead.
`protected static <R extends Record,T,U> TableField<R,U>`	`createField(String name, DataType<T> type, Table<R> table, String comment, Binding<T,U> binding)`	Deprecated. - 3.12.0 - [#8000] - Use `AbstractTable.createField(Name, DataType, Table, String, Binding)` instead.
`protected static <R extends Record,T,U> TableField<R,U>`	`createField(String name, DataType<T> type, Table<R> table, String comment, Converter<T,U> converter)`	Deprecated. - 3.12.0 - [#8000] - Use `AbstractTable.createField(Name, DataType, Table, String, Converter)` instead.
`protected static <R extends Record,T,X,U> TableField<R,U>`	`createField(String name, DataType<T> type, Table<R> table, String comment, Converter<X,U> converter, Binding<T,X> binding)`	Deprecated. - 3.12.0 - [#8000] - Use `AbstractTable.createField(Name, DataType, Table, String, Converter, Binding)` instead.
`protected <T> TableField<R,T>`	`createField(Name name, DataType<T> type)`	Subclasses may call this method to create `TableField` objects that are linked to this table.
`protected <T> TableField<R,T>`	`createField(Name name, DataType<T> type, String comment)`	Subclasses may call this method to create `TableField` objects that are linked to this table.
`protected <T,U> TableField<R,U>`	`createField(Name name, DataType<T> type, String comment, Binding<T,U> binding)`	Subclasses may call this method to create `TableField` objects that are linked to this table.
`protected <T,U> TableField<R,U>`	`createField(Name name, DataType<T> type, String comment, Converter<T,U> converter)`	Subclasses may call this method to create `TableField` objects that are linked to this table.
`protected <T,X,U> TableField<R,U>`	`createField(Name name, DataType<T> type, String comment, Converter<X,U> converter, Binding<T,X> binding)`	Subclasses may call this method to create `TableField` objects that are linked to this table.
`protected static <R extends Record,T> TableField<R,T>`	`createField(Name name, DataType<T> type, Table<R> table)`	Subclasses may call this method to create `TableField` objects that are linked to this table.
`protected static <R extends Record,T> TableField<R,T>`	`createField(Name name, DataType<T> type, Table<R> table, String comment)`	Subclasses may call this method to create `TableField` objects that are linked to this table.
`protected static <R extends Record,T,U> TableField<R,U>`	`createField(Name name, DataType<T> type, Table<R> table, String comment, Binding<T,U> binding)`	Subclasses may call this method to create `TableField` objects that are linked to this table.
`protected static <R extends Record,T,U> TableField<R,U>`	`createField(Name name, DataType<T> type, Table<R> table, String comment, Converter<T,U> converter)`	Subclasses may call this method to create `TableField` objects that are linked to this table.
`protected static <R extends Record,T,X,U> TableField<R,U>`	`createField(Name name, DataType<T> type, Table<R> table, String comment, Converter<X,U> converter, Binding<T,X> binding)`	Subclasses may call this method to create `TableField` objects that are linked to this table.
`Table<Record>`	`crossApply(String sql)`	`CROSS APPLY` a table to this table.
`Table<Record>`	`crossApply(String sql, Object... bindings)`	`CROSS APPLY` a table to this table.
`Table<Record>`	`crossApply(String sql, QueryPart... parts)`	`CROSS APPLY` a table to this table.
`Table<Record>`	`crossApply(Name name)`	`CROSS APPLY` a table to this table.
`Table<Record>`	`crossApply(SQL sql)`	`CROSS APPLY` a table to this table.
`Table<Record>`	`crossApply(TableLike<?> table)`	`CROSS APPLY` a table to this table.
`Table<Record>`	`crossJoin(String sql)`	`CROSS JOIN` a table to this table.
`Table<Record>`	`crossJoin(String sql, Object... bindings)`	`CROSS JOIN` a table to this table.
`Table<Record>`	`crossJoin(String sql, QueryPart... parts)`	`CROSS JOIN` a table to this table.
`Table<Record>`	`crossJoin(Name name)`	`CROSS JOIN` a table to this table.
`Table<Record>`	`crossJoin(SQL sql)`	`CROSS JOIN` a table to this table.
`Table<Record>`	`crossJoin(TableLike<?> table)`	`CROSS JOIN` a table to this table.
`boolean`	`declaresCTE()`	Subclasses may override this
`boolean`	`declaresFields()`	Subclasses may override this
`boolean`	`declaresTables()`	Subclasses may override this
`boolean`	`declaresWindows()`	Subclasses may override this
`DivideByOnStep`	`divideBy(Table<?> divisor)`	Create a new `TABLE` reference from this table, applying relational division.
`Condition`	`eq(Table<R> that)`	Create a predicate comparing records from self-joined tables.
`Condition`	`equal(Table<R> that)`	Create a predicate comparing records from self-joined tables.
`boolean`	`equals(Object that)`	Check whether this `QueryPart` can be considered equal to another `QueryPart`.
`Field<?>`	`field(int index)`	Get a specific field from this table, if this table knows its field references.
`<T> Field<T>`	`field(int index, Class<T> type)`	Get a specific field from this table and coerce it to `type`, if this table knows its field references.
`<T> Field<T>`	`field(int index, DataType<T> dataType)`	Get a specific field from this table and coerce it to `dataType`, if this table knows its field references.
`Field<?>`	`field(String string)`	Get a specific field from this table, if this table knows its field references.
`<T> Field<T>`	`field(String name, Class<T> type)`	Get a specific field from this table and coerce it to `type`, if this table knows its field references.
`<T> Field<T>`	`field(String name, DataType<T> dataType)`	Get a specific field from this table and coerce it to `dataType`, if this table knows its field references.
`<T> Field<T>`	`field(Field<T> field)`	Get a specific field from this table, if this table knows its field references.
`Field<?>`	`field(Name name)`	Get a specific field from this table, if this table knows its field references.
`<T> Field<T>`	`field(Name name, Class<T> type)`	Get a specific field from this table and coerce it to `type`, if this table knows its field references.
`<T> Field<T>`	`field(Name name, DataType<T> dataType)`	Get a specific field from this table and coerce it to `dataType`, if this table knows its field references.
`Field<?>[]`	`fields()`	Get all fields from this table, if this table knows its field references, or an empty array otherwise.
`Field<?>[]`	`fields(int... fieldIndexes)`	Get all fields from this table, providing some field indexes, if this table knows its field references.
`Field<?>[]`	`fields(String... fieldNames)`	Get all fields from this table, providing some field names, if this table knows its field references.
`Field<?>[]`	`fields(Field<?>... fields)`	Get all fields from this table, providing some fields, if this table knows its field references.
`Field<?>[]`	`fields(Name... fieldNames)`	Get all fields from this table, providing some field names, if this table knows its field references.
`Row`	`fieldsRow()`	Get this table's fields as a `Row`, if this table knows its field references.
`Stream<Field<?>>`	`fieldStream()`	Get this table's fields as a `Stream`, if this table knows its field references.
`Table<R>`	`for_(PeriodSpecification periodSpecification)`	Create a reference to a temporal table with a `PeriodSpecification` for usage in `Select`.
`Table<R>`	`forceIndex(String... indexes)`	Specify a MySQL style table hint for query optimisation.
`Table<R>`	`forceIndexForGroupBy(String... indexes)`	Specify a MySQL style table hint for query optimisation.
`Table<R>`	`forceIndexForJoin(String... indexes)`	Specify a MySQL style table hint for query optimisation.
`Table<R>`	`forceIndexForOrderBy(String... indexes)`	Specify a MySQL style table hint for query optimisation.
`Table<R>`	`forPortionOf(PeriodSpecification periodSpecification)`	Create a reference to a temporal table with a `PeriodSpecification` for usage in `Update` and `Delete`.
`R`	`from(Record record)`	The inverse operation of `Record.into(Table)`.
`TableOnStep<Record>`	`fullJoin(String sql)`	`FULL OUTER JOIN` a table to this table.
`TableOnStep<Record>`	`fullJoin(String sql, Object... bindings)`	`FULL OUTER JOIN` a table to this table.
`TableOnStep<Record>`	`fullJoin(String sql, QueryPart... parts)`	`FULL OUTER JOIN` a table to this table.
`TableOnStep<Record>`	`fullJoin(Name name)`	`FULL OUTER JOIN` a table to this table.
`TableOnStep<Record>`	`fullJoin(SQL sql)`	`FULL OUTER JOIN` a table to this table.
`TableOnStep<Record>`	`fullJoin(TableLike<?> table)`	`FULL OUTER JOIN` a table to this table.
`TableOnStep<Record>`	`fullOuterJoin(String sql)`	`FULL OUTER JOIN` a table to this table.
`TableOnStep<Record>`	`fullOuterJoin(String sql, Object... bindings)`	`FULL OUTER JOIN` a table to this table.
`TableOnStep<Record>`	`fullOuterJoin(String sql, QueryPart... parts)`	`FULL OUTER JOIN` a table to this table.
`TableOnStep<Record>`	`fullOuterJoin(Name name)`	`FULL OUTER JOIN` a table to this table.
`TableOnStep<Record>`	`fullOuterJoin(SQL sql)`	`FULL OUTER JOIN` a table to this table.
`TableOnStep<Record>`	`fullOuterJoin(TableLike<?> table)`	`FULL OUTER JOIN` a table to this table.
`boolean`	`generatesCast()`	Subclasses may override this
`Catalog`	`getCatalog()`	Get the object's catalog.
`List<Check<R>>`	`getChecks()`	Get a list of `CHECK` constraints of this table.
`String`	`getComment()`	The comment on this object.
`Comment`	`getCommentPart()`	The comment on this object as a `QueryPart`.
`DataType<R>`	`getDataType()`	The table's record type as a UDT data type, in case the underlying database supports table records as UDT records.
`Identity<R,?>`	`getIdentity()`	Retrieve the table's `IDENTITY` information, if available.
`List<Index>`	`getIndexes()`	Retrieve all of the table's indexes.
`List<UniqueKey<R>>`	`getKeys()`	Retrieve all of the table's unique keys.
`String`	`getName()`	The unqualified name of this object.
`TableOptions`	`getOptions()`	Get the table options.
`UniqueKey<R>`	`getPrimaryKey()`	Retrieve the table's primary key
`Name`	`getQualifiedName()`	The qualified name of this object.
`TableField<R,?>`	`getRecordTimestamp()`	A "timestamp" field holding record timestamp information used for optimistic locking
`Class<? extends R>`	`getRecordType()`	Subclasses must override this method if they use the generic type parameter for other types than `Record`
`TableField<R,?>`	`getRecordVersion()`	A "version" field holding record version information used for optimistic locking
`List<ForeignKey<R,?>>`	`getReferences()`	Get the list of `FOREIGN KEY`'s of this table
`<O extends Record> List<ForeignKey<O,R>>`	`getReferencesFrom(Table<O> other)`	Get a list of `FOREIGN KEY`'s of a specific table, referencing a this table.
`<O extends Record> List<ForeignKey<R,O>>`	`getReferencesTo(Table<O> other)`	Get a list of `FOREIGN KEY`'s of this table, referencing a specific table.
`Schema`	`getSchema()`	Get the object's schema.
`TableOptions.TableType`	`getType()`	Get the table type.
`Name`	`getUnqualifiedName()`	The unqualified name of this object.
`int`	`hashCode()`	Generate a hash code from this `QueryPart`.
`Table<R>`	`ignoreIndex(String... indexes)`	Specify a MySQL style table hint for query optimisation.
`Table<R>`	`ignoreIndexForGroupBy(String... indexes)`	Specify a MySQL style table hint for query optimisation.
`Table<R>`	`ignoreIndexForJoin(String... indexes)`	Specify a MySQL style table hint for query optimisation.
`Table<R>`	`ignoreIndexForOrderBy(String... indexes)`	Specify a MySQL style table hint for query optimisation.
`int`	`indexOf(String fieldName)`	Get a field's index from this table.
`int`	`indexOf(Field<?> field)`	Get a field's index from this table.
`int`	`indexOf(Name fieldName)`	Get a field's index from this table.
`TableOnStep<Record>`	`innerJoin(String sql)`	`INNER JOIN` a table to this table.
`TableOnStep<Record>`	`innerJoin(String sql, Object... bindings)`	`INNER JOIN` a table to this table.
`TableOnStep<Record>`	`innerJoin(String sql, QueryPart... parts)`	`INNER JOIN` a table to this table.
`TableOnStep<Record>`	`innerJoin(Name name)`	`INNER JOIN` a table to this table.
`TableOnStep<Record>`	`innerJoin(SQL sql)`	`INNER JOIN` a table to this table.
`TableOnStep<Record>`	`innerJoin(TableLike<?> table)`	`INNER JOIN` a table to this table.
`TableOnStep<Record>`	`join(String sql)`	`INNER JOIN` a table to this table.
`TableOnStep<Record>`	`join(String sql, Object... bindings)`	`INNER JOIN` a table to this table.
`TableOnStep<Record>`	`join(String sql, QueryPart... parts)`	`INNER JOIN` a table to this table.
`TableOnStep<Record>`	`join(Name name)`	`INNER JOIN` a table to this table.
`TableOnStep<Record>`	`join(SQL sql)`	`INNER JOIN` a table to this table.
`TableOnStep<Record>`	`join(TableLike<?> table)`	`INNER JOIN` a table to this table.
`TableOptionalOnStep<Record>`	`join(TableLike<?> table, JoinType type)`	Join a table to this table using a `JoinType`
`TableOnStep<R>`	`leftAntiJoin(TableLike<?> table)`	A synthetic `LEFT ANTI JOIN` clause that translates to an equivalent `NOT EXISTS` predicate.
`TablePartitionByStep<Record>`	`leftJoin(String sql)`	`LEFT OUTER JOIN` a table to this table.
`TablePartitionByStep<Record>`	`leftJoin(String sql, Object... bindings)`	`LEFT OUTER JOIN` a table to this table.
`TablePartitionByStep<Record>`	`leftJoin(String sql, QueryPart... parts)`	`LEFT OUTER JOIN` a table to this table.
`TablePartitionByStep<Record>`	`leftJoin(Name name)`	`LEFT OUTER JOIN` a table to this table.
`TablePartitionByStep<Record>`	`leftJoin(SQL sql)`	`LEFT OUTER JOIN` a table to this table.
`TablePartitionByStep<Record>`	`leftJoin(TableLike<?> table)`	`LEFT OUTER JOIN` a table to this table.
`TablePartitionByStep<Record>`	`leftOuterJoin(String sql)`	`LEFT OUTER JOIN` a table to this table.
`TablePartitionByStep<Record>`	`leftOuterJoin(String sql, Object... bindings)`	`LEFT OUTER JOIN` a table to this table.
`TablePartitionByStep<Record>`	`leftOuterJoin(String sql, QueryPart... parts)`	`LEFT OUTER JOIN` a table to this table.
`TablePartitionByStep<Record>`	`leftOuterJoin(Name name)`	`LEFT OUTER JOIN` a table to this table.
`TablePartitionByStep<Record>`	`leftOuterJoin(SQL sql)`	`LEFT OUTER JOIN` a table to this table.
`TablePartitionByStep<Record>`	`leftOuterJoin(TableLike<?> table)`	`LEFT OUTER JOIN` a table to this table.
`TableOnStep<R>`	`leftSemiJoin(TableLike<?> table)`	A synthetic `LEFT SEMI JOIN` clause that translates to an equivalent `EXISTS` predicate.
`Table<Record>`	`naturalFullOuterJoin(String sql)`	`NATURAL FULL OUTER JOIN` a table to this table.
`Table<Record>`	`naturalFullOuterJoin(String sql, Object... bindings)`	`NATURAL FULL OUTER JOIN` a table to this table.
`Table<Record>`	`naturalFullOuterJoin(String sql, QueryPart... parts)`	`NATURAL FULL OUTER JOIN` a table to this table.
`Table<Record>`	`naturalFullOuterJoin(Name name)`	`NATURAL FULL OUTER JOIN` a table to this table.
`Table<Record>`	`naturalFullOuterJoin(SQL sql)`	`NATURAL FULL OUTER JOIN` a table to this table.
`Table<Record>`	`naturalFullOuterJoin(TableLike<?> table)`	`NATURAL FULL OUTER JOIN` a table to this table.
`Table<Record>`	`naturalJoin(String sql)`	`NATURAL JOIN` a table to this table.
`Table<Record>`	`naturalJoin(String sql, Object... bindings)`	`NATURAL JOIN` a table to this table.
`Table<Record>`	`naturalJoin(String sql, QueryPart... parts)`	`NATURAL JOIN` a table to this table.
`Table<Record>`	`naturalJoin(Name name)`	`NATURAL JOIN` a table to this table.
`Table<Record>`	`naturalJoin(SQL sql)`	`NATURAL JOIN` a table to this table.
`Table<Record>`	`naturalJoin(TableLike<?> table)`	`NATURAL JOIN` a table to this table.
`Table<Record>`	`naturalLeftOuterJoin(String sql)`	`NATURAL LEFT OUTER JOIN` a table to this table.
`Table<Record>`	`naturalLeftOuterJoin(String sql, Object... bindings)`	`NATURAL LEFT OUTER JOIN` a table to this table.
`Table<Record>`	`naturalLeftOuterJoin(String sql, QueryPart... parts)`	`NATURAL LEFT OUTER JOIN` a table to this table.
`Table<Record>`	`naturalLeftOuterJoin(Name name)`	`NATURAL LEFT OUTER JOIN` a table to this table.
`Table<Record>`	`naturalLeftOuterJoin(SQL sql)`	`NATURAL LEFT OUTER JOIN` a table to this table.
`Table<Record>`	`naturalLeftOuterJoin(TableLike<?> table)`	`NATURAL LEFT OUTER JOIN` a table to this table.
`Table<Record>`	`naturalRightOuterJoin(String sql)`	`NATURAL RIGHT OUTER JOIN` a table to this table.
`Table<Record>`	`naturalRightOuterJoin(String sql, Object... bindings)`	`NATURAL RIGHT OUTER JOIN` a table to this table.
`Table<Record>`	`naturalRightOuterJoin(String sql, QueryPart... parts)`	`NATURAL RIGHT OUTER JOIN` a table to this table.
`Table<Record>`	`naturalRightOuterJoin(Name name)`	`NATURAL RIGHT OUTER JOIN` a table to this table.
`Table<Record>`	`naturalRightOuterJoin(SQL sql)`	`NATURAL RIGHT OUTER JOIN` a table to this table.
`Table<Record>`	`naturalRightOuterJoin(TableLike<?> table)`	`NATURAL RIGHT OUTER JOIN` a table to this table.
`Condition`	`ne(Table<R> that)`	Create a predicate comparing records from self-non-equi-joined tables.
`R`	`newRecord()`	Create a new `Record` of this table's type.
`Condition`	`notEqual(Table<R> that)`	Create a predicate comparing records from self-non-equi-joined tables.
`Table<Record>`	`outerApply(String sql)`	`OUTER APPLY` a table to this table.
`Table<Record>`	`outerApply(String sql, Object... bindings)`	`OUTER APPLY` a table to this table.
`Table<Record>`	`outerApply(String sql, QueryPart... parts)`	`OUTER APPLY` a table to this table.
`Table<Record>`	`outerApply(Name name)`	`OUTER APPLY` a table to this table.
`Table<Record>`	`outerApply(SQL sql)`	`OUTER APPLY` a table to this table.
`Table<Record>`	`outerApply(TableLike<?> table)`	`OUTER APPLY` a table to this table.
`TableOuterJoinStep<Record>`	`partitionBy(Collection<? extends Field<?>> fields)`	Add a `PARTITION BY` clause to the left hand side of the `OUTER JOIN` keywords
`TableOuterJoinStep<Record>`	`partitionBy(Field<?>... fields)`	Add a `PARTITION BY` clause to the left hand side of the `OUTER JOIN` keywords
`PivotForStep`	`pivot(Collection<? extends Field<?>> aggregateFunctions)`	Create a new `TABLE` reference from this table, pivoting it into another form.
`PivotForStep`	`pivot(Field<?>... aggregateFunctions)`	Create a new `TABLE` reference from this table, pivoting it into another form.
`RecordType<R>`	`recordType()`	The record type produced by this table.
`Table<R>`	`rename(String rename)`
`Table<R>`	`rename(Name rename)`
`boolean`	`rendersContent(Context<?> ctx)`	Subclasses may override this
`TablePartitionByStep<Record>`	`rightJoin(String sql)`	`RIGHT OUTER JOIN` a table to this table.
`TablePartitionByStep<Record>`	`rightJoin(String sql, Object... bindings)`	`RIGHT OUTER JOIN` a table to this table.
`TablePartitionByStep<Record>`	`rightJoin(String sql, QueryPart... parts)`	`RIGHT OUTER JOIN` a table to this table.
`TablePartitionByStep<Record>`	`rightJoin(Name name)`	`RIGHT OUTER JOIN` a table to this table.
`TablePartitionByStep<Record>`	`rightJoin(SQL sql)`	`RIGHT OUTER JOIN` a table to this table.
`TablePartitionByStep<Record>`	`rightJoin(TableLike<?> table)`	`RIGHT OUTER JOIN` a table to this table.
`TablePartitionByStep<Record>`	`rightOuterJoin(String sql)`	`RIGHT OUTER JOIN` a table to this table.
`TablePartitionByStep<Record>`	`rightOuterJoin(String sql, Object... bindings)`	`RIGHT OUTER JOIN` a table to this table.
`TablePartitionByStep<Record>`	`rightOuterJoin(String sql, QueryPart... parts)`	`RIGHT OUTER JOIN` a table to this table.
`TablePartitionByStep<Record>`	`rightOuterJoin(Name name)`	`RIGHT OUTER JOIN` a table to this table.
`TablePartitionByStep<Record>`	`rightOuterJoin(SQL sql)`	`RIGHT OUTER JOIN` a table to this table.
`TablePartitionByStep<Record>`	`rightOuterJoin(TableLike<?> table)`	`RIGHT OUTER JOIN` a table to this table.
`Field<RowId>`	`rowid()`	Get a `table.rowid` reference from this table.
`TableOptionalOnStep<Record>`	`straightJoin(String sql)`	`STRAIGHT_JOIN` a table to this table.
`TableOptionalOnStep<Record>`	`straightJoin(String sql, Object... bindings)`	`STRAIGHT_JOIN` a table to this table.
`TableOptionalOnStep<Record>`	`straightJoin(String sql, QueryPart... parts)`	`STRAIGHT_JOIN` a table to this table.
`TableOptionalOnStep<Record>`	`straightJoin(Name name)`	`STRAIGHT_JOIN` a table to this table.
`TableOptionalOnStep<Record>`	`straightJoin(SQL sql)`	`STRAIGHT_JOIN` a table to this table.
`TableOptionalOnStep<Record>`	`straightJoin(TableLike<?> table)`	`STRAIGHT_JOIN` a table to this table.
`void`	`toSQL(RenderContext context)`	Deprecated. - 3.4.0 - [#2694] - Use `QueryPartInternal.accept(Context)` instead.
`String`	`toString()`	Render a SQL string representation of this `QueryPart`.
`protected DataAccessException`	`translate(String sql, SQLException e)`	Internal convenience method
`Table<R>`	`useIndex(String... indexes)`	Specify a MySQL style table hint for query optimisation.
`Table<R>`	`useIndexForGroupBy(String... indexes)`	Specify a MySQL style table hint for query optimisation.
`Table<R>`	`useIndexForJoin(String... indexes)`	Specify a MySQL style table hint for query optimisation.
`Table<R>`	`useIndexForOrderBy(String... indexes)`	Specify a MySQL style table hint for query optimisation.
`VersionsBetweenAndStep<R,Number>`	`versionsBetweenScn(Number scn)`	Create an `SQLDialect.ORACLE` flashback versions query clause from this table.
`VersionsBetweenAndStep<R,Number>`	`versionsBetweenScn(Field<? extends Number> scn)`	Create an `SQLDialect.ORACLE` flashback versions query clause from this table.
`VersionsBetweenAndStep<R,Number>`	`versionsBetweenScnMinvalue()`	Create an `SQLDialect.ORACLE` flashback versions query clause from this table.
`VersionsBetweenAndStep<R,Timestamp>`	`versionsBetweenTimestamp(Timestamp timestamp)`	Create an `SQLDialect.ORACLE` flashback versions query clause from this table.
`VersionsBetweenAndStep<R,Timestamp>`	`versionsBetweenTimestamp(Field<Timestamp> timestamp)`	Create an `SQLDialect.ORACLE` flashback versions query clause from this table.
`VersionsBetweenAndStep<R,Timestamp>`	`versionsBetweenTimestampMinvalue()`	Create an `SQLDialect.ORACLE` flashback versions query clause from this table.
`Table<R>`	`where(String sql)`	Add a `WHERE` clause to the table.
`Table<R>`	`where(String sql, Object... bindings)`	Add a `WHERE` clause to the table.
`Table<R>`	`where(String sql, QueryPart... parts)`	Add a `WHERE` clause to the table.
`Table<R>`	`where(Collection<? extends Condition> conditions)`	Add a `WHERE` clause to the table, connecting them with each other with `Operator.AND`.
`Table<R>`	`where(Condition condition)`	Add a `WHERE` clause to the table, connecting them with each other with `Operator.AND`.
`Table<R>`	`where(Condition... conditions)`	Add a `WHERE` clause to the table, connecting them with each other with `Operator.AND`.
`Table<R>`	`where(Field<Boolean> field)`	Add a `WHERE` clause to the table.
`Table<R>`	`where(SQL sql)`	Add a `WHERE` clause to the table.
`Table<R>`	`whereExists(Select<?> select)`	Add a `WHERE EXISTS` clause to the table.
`Table<R>`	`whereNotExists(Select<?> select)`	Add a `WHERE NOT EXISTS` clause to the table.
`Table<R>`	`with(String hint)`	Specify a SQL Server style table hint for query optimisation.
`Table<R>`	`with(String hint, Object... binds)`	Specify a SQL Server style table hint for query optimisation.
`Table<R>`	`with(String hint, QueryPart... parts)`	Specify a SQL Server style table hint for query optimisation.
`Table<R>`	`with(SQL hint)`	Specify a SQL Server style table hint for query optimisation.

Methods inherited from class java.lang.Object
clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.jooq.Named
getComment, getCommentPart, getName, getQualifiedName, getUnqualifiedName

Methods inherited from interface org.jooq.QueryPart
hashCode, toString

- Field Detail
  - parameters
```
protected final Field<?>[] parameters
```
- Constructor Detail
  - TableImpl
```
@Deprecated
public TableImpl(String name)
```
    Deprecated.
    - 3.10 - [#5996] - Use TableImpl(Name) instead (or re-generated your code).
  - TableImpl
```
@Deprecated
public TableImpl(String name,
                 Schema schema)
```
    Deprecated.
    - 3.10 - [#5996] - Use TableImpl(Name, Schema) instead (or re-generated your code).
  - TableImpl
```
@Deprecated
public TableImpl(String name,
                 Schema schema,
                 Table<R> aliased)
```
    Deprecated.
    - 3.10 - [#5996] - Use TableImpl(Name, Schema, Table) instead (or re-generated your code).
  - TableImpl
```
@Deprecated
public TableImpl(String name,
                 Schema schema,
                 Table<R> aliased,
                 Field<?>[] parameters)
```
    Deprecated.
    - 3.10 - [#5996] - Use TableImpl(Name, Schema, Table, Field[]) instead (or re-generated your code).
  - TableImpl
```
@Deprecated
public TableImpl(String name,
                 Schema schema,
                 Table<R> aliased,
                 Field<?>[] parameters,
                 String comment)
```
    Deprecated.
    - 3.10 - [#5996] - Use TableImpl(Name, Schema, Table, Field[], String) instead (or re-generated your code).
  - TableImpl
```
public TableImpl(Name name)
```
  - TableImpl
```
public TableImpl(Name name,
                 Schema schema)
```
  - TableImpl
```
public TableImpl(Name name,
                 Schema schema,
                 Table<R> aliased)
```
  - TableImpl
```
public TableImpl(Name name,
                 Schema schema,
                 Table<R> aliased,
                 Field<?>[] parameters)
```
  - TableImpl
```
@Deprecated
public TableImpl(Name name,
                 Schema schema,
                 Table<R> aliased,
                 Field<?>[] parameters,
                 String comment)
```
    Deprecated.
    - 3.11 - [#7027] - Use TableImpl(Name, Schema, Table, Field[], Comment) instead.
  - TableImpl
```
public TableImpl(Name name,
                 Schema schema,
                 Table<R> aliased,
                 Field<?>[] parameters,
                 Comment comment)
```
  - TableImpl
```
public TableImpl(Name name,
                 Schema schema,
                 Table<R> aliased,
                 Field<?>[] parameters,
                 Comment comment,
                 TableOptions options)
```
  - TableImpl
```
public TableImpl(Table<?> child,
                 ForeignKey<?,R> path,
                 Table<R> parent)
```
  - TableImpl
```
public TableImpl(Name name,
                 Schema schema,
                 Table<?> child,
                 ForeignKey<?,R> path,
                 Table<R> aliased,
                 Field<?>[] parameters,
                 Comment comment)
```
  - TableImpl
```
public TableImpl(Name name,
                 Schema schema,
                 Table<?> child,
                 ForeignKey<?,R> path,
                 Table<R> aliased,
                 Field<?>[] parameters,
                 Comment comment,
                 TableOptions options)
```
- Method Detail
  - aliased
```
@Internal
protected boolean aliased()
```
    Check if this table already aliases another one.
    This method is used by generated code of table valued functions. Do not call this method directly.
  - fieldsRow
```
public Row fieldsRow()
```
    Description copied from interface: TableLike
    
    Get this table's fields as a Row, if this table knows its field references.
    
    Specified by:
    
    fieldsRow in interface TableLike<R extends Record>
  - clauses
```
public final Clause[] clauses(Context<?> ctx)
```
    Description copied from interface: QueryPartInternal
    
    The Clauses that are represented by this query part.
    QueryParts can specify several Clauses for which an event will be emitted before (in forward order) and after (in reverse order) visiting the the query part through Context.visit(QueryPart)
    This method is for JOOQ INTERNAL USE only. Do not reference directly
    
    Specified by:
    
    clauses in interface QueryPartInternal
    
    Returns:
    
    The Clauses represented by this query part or null or an empty array if this query part does not represent a clause.
  - accept
```
public final void accept(Context<?> ctx)
```
    Description copied from interface: QueryPartInternal
    
    This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.
  - as
```
public Table<R> as(Name as)
```
    Subclasses may override this method to provide custom aliasing implementations
    Create an alias for this table.
    Note that the case-sensitivity of the returned table depends on Settings.getRenderQuotedNames() and the Name. By default, table aliases are quoted, and thus case-sensitive in many SQL dialects - use DSL.unquotedName(String...) for case-insensitive aliases.
    If the argument Name.getName() is qualified, then the Name.last() part will be used.
    
    Specified by:
    
    as in interface Table<R extends Record>
    
    Parameters:
    
    as - The alias name
    
    Returns:
    
    The table alias
  - as
```
public Table<R> as(Name as,
                   Name... fieldAliases)
```
    Subclasses may override this method to provide custom aliasing implementations
    Create an alias for this table and its fields.
    Note that the case-sensitivity of the returned table depends on Settings.getRenderQuotedNames() and the Name. By default, table aliases are quoted, and thus case-sensitive in many SQL dialects - use DSL.unquotedName(String...) for case-insensitive aliases.
    If the argument Name.getName() is qualified, then the Name.last() part will be used.
    
    Derived column lists for table references
    
    Note, not all databases support derived column lists for their table aliases. On the other hand, some databases do support derived column lists, but only for derived tables. jOOQ will try to turn table references into derived tables to make this syntax work. In other words, the following statements are equivalent:
    -- Using derived column lists to rename columns (e.g. Postgres) SELECT t.a, t.b FROM my_table t(a, b) -- Nesting table references within derived tables (e.g. SQL Server) SELECT t.a, t.b FROM ( SELECT * FROM my_table ) t(a, b)
    
    Derived column lists for derived tables
    
    Other databases may not support derived column lists at all, but they do support common table expressions. The following statements are equivalent:
    -- Using derived column lists to rename columns (e.g. Postgres) SELECT t.a, t.b FROM ( SELECT 1, 2 ) AS t(a, b) -- Using UNION ALL to produce column names (e.g. MySQL) SELECT t.a, t.b FROM ( SELECT null a, null b FROM DUAL WHERE 1 = 0 UNION ALL SELECT 1, 2 FROM DUAL ) t
    Specified by:
    
    as in interface Table<R extends Record>
    
    Parameters:
    
    as - The alias name
    
    fieldAliases - The field aliases. Excess aliases are ignored, missing aliases will be substituted by this table's field names.
    
    Returns:
    
    The table alias
  - rename
```
public Table<R> rename(String rename)
```
  - rename
```
public Table<R> rename(Name rename)
```
  - getRecordType
```
public Class<? extends R> getRecordType()
```
    Subclasses must override this method if they use the generic type parameter for other types than Record
    The record type produced by this table.
  - declaresTables
```
public boolean declaresTables()
```
    Subclasses may override this
    
    Specified by:
    
    declaresTables in interface QueryPartInternal
  - equals
```
public boolean equals(Object that)
```
    Description copied from interface: QueryPart
    
    Check whether this QueryPart can be considered equal to another QueryPart.
    In general, QueryPart equality is defined in terms of QueryPart.toString() equality. In other words, two query parts are considered equal if their rendered SQL (with inlined bind variables) is equal. This means that the two query parts do not necessarily have to be of the same type.
    Some QueryPart implementations may choose to override this behaviour for improved performance, as QueryPart.toString() is an expensive operation, if called many times.
    
    Specified by:
    
    equals in interface QueryPart
    
    Specified by:
    
    equals in interface Table<R extends Record>
    
    Parameters:
    
    that - The other QueryPart
    
    Returns:
    
    Whether the two query parts are equal
  - from
```
public final R from(Record record)
```
    Description copied from interface: Table
    The inverse operation of Record.into(Table).
    This method can be used in its method reference form conveniently on a generated table, for instance, when mapping records in a stream:
    DSL.using(configuration) .fetch("select * from t") .stream() .map(MY_TABLE::into) .forEach(System.out::println);
    Specified by:
    
    from in interface Table<R extends Record>
  - asterisk
```
public final QualifiedAsterisk asterisk()
```
    Description copied from interface: Table
    
    Create a qualified asterisk expression from this table (table.*) for use with SELECT.
    
    Specified by:
    
    asterisk in interface Table<R extends Record>
    
    See Also:
    
    DSL.asterisk()
  - rowid
```
public final Field<RowId> rowid()
```
    Description copied from interface: Table
    Get a table.rowid reference from this table.
    A rowid value describes the physical location of a row on the disk, which can be used as a replacement for a primary key in some situations - especially within a query, e.g. to self-join a table:
    
    -- Emulating this MySQL statement... DELETE FROM x ORDER BY x.y LIMIT 1 -- ... in other databases DELETE FROM x WHERE x.rowid IN ( SELECT x.rowid FROM x ORDER BY x.a LIMIT 1 )
    
    It is not recommended to use rowid values in client applications as actual row identifiers as the database system may move a row to a different physical location at any time, thus changing the rowid value. In general, use primary keys, instead.
    Specified by:
    
    rowid in interface Table<R extends Record>
  - getDataType
```
public final DataType<R> getDataType()
```
    Description copied from interface: Table
    
    The table's record type as a UDT data type, in case the underlying database supports table records as UDT records.
    
    Specified by:
    
    getDataType in interface Table<R extends Record>
  - recordType
```
public final RecordType<R> recordType()
```
    Description copied from interface: Table
    
    The record type produced by this table.
    
    Specified by:
    
    recordType in interface Table<R extends Record>
  - newRecord
```
public final R newRecord()
```
    Description copied from interface: Table
    
    Create a new Record of this table's type.
    
    Specified by:
    
    newRecord in interface Table<R extends Record>
    
    See Also:
    
    DSLContext.newRecord(Table)
  - fieldStream
```
public final Stream<Field<?>> fieldStream()
```
    Description copied from interface: TableLike
    
    Get this table's fields as a Stream, if this table knows its field references.
    
    Specified by:
    
    fieldStream in interface TableLike<R extends Record>
  - field
```
public final <T> Field<T> field(Field<T> field)
```
    Description copied from interface: TableLike
    Get a specific field from this table, if this table knows its field references.
    This will return:
    
    A field that is the same as the argument field (by identity comparison).
    
    A field that is equal to the argument field (exact matching fully qualified name).
    
    A field that is equal to the argument field (partially matching qualified name).
    
    A field whose name is equal to the name of the argument field.
    
    null otherwise.
    If several fields have the same name, the first one is returned and a warning is logged.
    Specified by:
    
    field in interface TableLike<R extends Record>
    
    See Also:
    
    Row.field(Field)
  - field
```
public final Field<?> field(String string)
```
    Description copied from interface: TableLike
    
    Get a specific field from this table, if this table knows its field references.
    
    Specified by:
    
    field in interface TableLike<R extends Record>
    
    See Also:
    
    Row.field(String)
  - field
```
public final <T> Field<T> field(String name,
                                Class<T> type)
```
    Description copied from interface: TableLike
    
    Get a specific field from this table and coerce it to type, if this table knows its field references.
    
    Specified by:
    
    field in interface TableLike<R extends Record>
    
    See Also:
    
    Row.field(String, Class)
  - field
```
public final <T> Field<T> field(String name,
                                DataType<T> dataType)
```
    Description copied from interface: TableLike
    
    Get a specific field from this table and coerce it to dataType, if this table knows its field references.
    
    Specified by:
    
    field in interface TableLike<R extends Record>
    
    See Also:
    
    Row.field(String, DataType)
  - field
```
public final Field<?> field(Name name)
```
    Description copied from interface: TableLike
    
    Get a specific field from this table, if this table knows its field references.
    
    Specified by:
    
    field in interface TableLike<R extends Record>
    
    See Also:
    
    Row.field(Name)
  - field
```
public final <T> Field<T> field(Name name,
                                Class<T> type)
```
    Description copied from interface: TableLike
    
    Get a specific field from this table and coerce it to type, if this table knows its field references.
    
    Specified by:
    
    field in interface TableLike<R extends Record>
    
    See Also:
    
    Row.field(Name, Class)
  - field
```
public final <T> Field<T> field(Name name,
                                DataType<T> dataType)
```
    Description copied from interface: TableLike
    
    Get a specific field from this table and coerce it to dataType, if this table knows its field references.
    
    Specified by:
    
    field in interface TableLike<R extends Record>
    
    See Also:
    
    Row.field(Name, DataType)
  - field
```
public final Field<?> field(int index)
```
    Description copied from interface: TableLike
    
    Get a specific field from this table, if this table knows its field references.
    
    Specified by:
    
    field in interface TableLike<R extends Record>
    
    See Also:
    
    Row.field(int)
  - field
```
public final <T> Field<T> field(int index,
                                Class<T> type)
```
    Description copied from interface: TableLike
    
    Get a specific field from this table and coerce it to type, if this table knows its field references.
    
    Specified by:
    
    field in interface TableLike<R extends Record>
    
    See Also:
    
    Row.field(int, Class)
  - field
```
public final <T> Field<T> field(int index,
                                DataType<T> dataType)
```
    Description copied from interface: TableLike
    
    Get a specific field from this table and coerce it to dataType, if this table knows its field references.
    
    Specified by:
    
    field in interface TableLike<R extends Record>
    
    See Also:
    
    Row.field(int, DataType)
  - fields
```
public final Field<?>[] fields()
```
    Description copied from interface: TableLike
    
    Get all fields from this table, if this table knows its field references, or an empty array otherwise.
    
    Specified by:
    
    fields in interface TableLike<R extends Record>
    
    See Also:
    
    Row.fields()
  - fields
```
public final Field<?>[] fields(Field<?>... fields)
```
    Description copied from interface: TableLike
    
    Get all fields from this table, providing some fields, if this table knows its field references.
    
    Specified by:
    
    fields in interface TableLike<R extends Record>
    
    Returns:
    
    All available fields
    
    See Also:
    
    Row.fields(Field...)
  - fields
```
public final Field<?>[] fields(String... fieldNames)
```
    Description copied from interface: TableLike
    
    Get all fields from this table, providing some field names, if this table knows its field references.
    
    Specified by:
    
    fields in interface TableLike<R extends Record>
    
    Returns:
    
    All available fields
    
    See Also:
    
    Row.fields(String...)
  - fields
```
public final Field<?>[] fields(Name... fieldNames)
```
    Description copied from interface: TableLike
    
    Get all fields from this table, providing some field names, if this table knows its field references.
    
    Specified by:
    
    fields in interface TableLike<R extends Record>
    
    Returns:
    
    All available fields
    
    See Also:
    
    Row.fields(Name...)
  - fields
```
public final Field<?>[] fields(int... fieldIndexes)
```
    Description copied from interface: TableLike
    
    Get all fields from this table, providing some field indexes, if this table knows its field references.
    
    Specified by:
    
    fields in interface TableLike<R extends Record>
    
    Returns:
    
    All available fields
    
    See Also:
    
    Row.fields(int...)
  - indexOf
```
public final int indexOf(Field<?> field)
```
    Description copied from interface: TableLike
    
    Get a field's index from this table.
    
    Specified by:
    
    indexOf in interface TableLike<R extends Record>
    
    Parameters:
    
    field - The field to look for
    
    Returns:
    
    The field's index or -1 if the field is not contained in this table.
  - indexOf
```
public final int indexOf(String fieldName)
```
    Description copied from interface: TableLike
    
    Get a field's index from this table.
    
    Specified by:
    
    indexOf in interface TableLike<R extends Record>
    
    Parameters:
    
    fieldName - The field name to look for
    
    Returns:
    
    The field's index or -1 if the field is not contained in this table.
  - indexOf
```
public final int indexOf(Name fieldName)
```
    Description copied from interface: TableLike
    
    Get a field's index from this table.
    
    Specified by:
    
    indexOf in interface TableLike<R extends Record>
    
    Parameters:
    
    fieldName - The field name to look for
    
    Returns:
    
    The field's index or -1 if the field is not contained in this table
  - asTable
```
public final Table<R> asTable()
```
    Description copied from interface: TableLike
    
    The underlying table representation of this object.
    This method is useful for things like SELECT * FROM (SELECT * FROM x WHERE x.a = '1') WHERE ...
    
    Specified by:
    
    asTable in interface TableLike<R extends Record>
  - asTable
```
public final Table<R> asTable(String alias)
```
    Description copied from interface: TableLike
    
    The underlying aliased table representation of this object.
    
    Specified by:
    
    asTable in interface TableLike<R extends Record>
    
    See Also:
    
    Table.as(String)
  - asTable
```
public final Table<R> asTable(String alias,
                              String... fieldAliases)
```
    Description copied from interface: TableLike
    
    The underlying aliased table representation of this object.
    
    Specified by:
    
    asTable in interface TableLike<R extends Record>
    
    See Also:
    
    Table.as(String, String...)
  - asTable
```
public final Table<R> asTable(Name alias)
```
    Description copied from interface: TableLike
    
    The underlying aliased table representation of this object.
    
    Specified by:
    
    asTable in interface TableLike<R extends Record>
    
    See Also:
    
    Table.as(Name)
  - asTable
```
public final Table<R> asTable(Name alias,
                              Name... fieldAliases)
```
    Description copied from interface: TableLike
    
    The underlying aliased table representation of this object.
    
    Specified by:
    
    asTable in interface TableLike<R extends Record>
    
    See Also:
    
    Table.as(String, String...)
  - asTable
```
public final Table<R> asTable(Table<?> alias)
```
    Description copied from interface: TableLike
    
    The underlying aliased table representation of this object.
    
    Specified by:
    
    asTable in interface TableLike<R extends Record>
    
    See Also:
    
    Table.as(Name)
  - asTable
```
public final Table<R> asTable(Table<?> alias,
                              Field<?>... fieldAliases)
```
    Description copied from interface: TableLike
    
    The underlying aliased table representation of this object.
    
    Specified by:
    
    asTable in interface TableLike<R extends Record>
    
    See Also:
    
    Table.as(String, String...)
  - asTable
```
public final Table<R> asTable(String alias,
                              Function<? super Field<?>,? extends String> aliasFunction)
```
    Description copied from interface: TableLike
    
    The underlying aliased table representation of this object.
    
    Specified by:
    
    asTable in interface TableLike<R extends Record>
    
    See Also:
    
    Table.as(String, Function)
  - asTable
```
public final Table<R> asTable(String alias,
                              BiFunction<? super Field<?>,? super Integer,? extends String> aliasFunction)
```
    Description copied from interface: TableLike
    
    The underlying aliased table representation of this object.
    
    Specified by:
    
    asTable in interface TableLike<R extends Record>
    
    See Also:
    
    Table.as(String, BiFunction)
  - as
```
public Table<R> as(String alias)
```
    Description copied from interface: Table
    
    Create an alias for this table.
    Note that the case-sensitivity of the returned table depends on Settings.getRenderQuotedNames(). By default, table aliases are quoted, and thus case-sensitive in many SQL dialects!
    
    Specified by:
    
    as in interface Table<R extends Record>
    
    Parameters:
    
    alias - The alias name
    
    Returns:
    
    The table alias
  - as
```
public Table<R> as(String alias,
                   String... fieldAliases)
```
    Description copied from interface: Table
    Create an alias for this table and its fields.
    Note that the case-sensitivity of the returned table and columns depends on Settings.getRenderQuotedNames(). By default, table aliases are quoted, and thus case-sensitive in many SQL dialects!
    
    Derived column lists for table references
    
    Note, not all databases support derived column lists for their table aliases. On the other hand, some databases do support derived column lists, but only for derived tables. jOOQ will try to turn table references into derived tables to make this syntax work. In other words, the following statements are equivalent:
    -- Using derived column lists to rename columns (e.g. Postgres) SELECT t.a, t.b FROM my_table t(a, b) -- Nesting table references within derived tables (e.g. SQL Server) SELECT t.a, t.b FROM ( SELECT * FROM my_table ) t(a, b)
    
    Derived column lists for derived tables
    
    Other databases may not support derived column lists at all, but they do support common table expressions. The following statements are equivalent:
    -- Using derived column lists to rename columns (e.g. Postgres) SELECT t.a, t.b FROM ( SELECT 1, 2 ) AS t(a, b) -- Using UNION ALL to produce column names (e.g. MySQL) SELECT t.a, t.b FROM ( SELECT null a, null b FROM DUAL WHERE 1 = 0 UNION ALL SELECT 1, 2 FROM DUAL ) t
    Specified by:
    
    as in interface Table<R extends Record>
    
    Parameters:
    
    alias - The alias name
    
    fieldAliases - The field aliases. Excess aliases are ignored, missing aliases will be substituted by this table's field names.
    
    Returns:
    
    The table alias
  - as
```
public final Table<R> as(String alias,
                         Function<? super Field<?>,? extends String> aliasFunction)
```
    Description copied from interface: Table
    Create an alias for this table and its fields.
    This works like Table.as(String, String...), except that field aliases are provided by a function. This is useful, for instance, to prefix all columns with a common prefix:
    
    MY_TABLE.as("t1", f ->"prefix_" + f.getName());
    Specified by:
    
    as in interface Table<R extends Record>
    
    Parameters:
    
    alias - The alias name
    
    aliasFunction - The function providing field aliases.
    
    Returns:
    
    The table alias
  - as
```
public final Table<R> as(String alias,
                         BiFunction<? super Field<?>,? super Integer,? extends String> aliasFunction)
```
    Description copied from interface: Table
    Create an alias for this table and its fields.
    This works like Table.as(String, String...), except that field aliases are provided by a function. This is useful, for instance, to prefix all columns with a common prefix:
    
    MY_TABLE.as("t1", (f, i) ->"column" + i);
    Specified by:
    
    as in interface Table<R extends Record>
    
    Parameters:
    
    alias - The alias name
    
    aliasFunction - The function providing field aliases.
    
    Returns:
    
    The table alias
  - as
```
public final Table<R> as(Name alias,
                         Function<? super Field<?>,? extends Name> aliasFunction)
```
    Description copied from interface: Table
    Create an alias for this table and its fields.
    This works like Table.as(Name, Name...), except that field aliases are provided by a function. This is useful, for instance, to prefix all columns with a common prefix:
    
    MY_TABLE.as("t1", f ->"prefix_" + f.getName());
    Specified by:
    
    as in interface Table<R extends Record>
    
    Parameters:
    
    alias - The alias name
    
    aliasFunction - The function providing field aliases.
    
    Returns:
    
    The table alias
  - as
```
public final Table<R> as(Name alias,
                         BiFunction<? super Field<?>,? super Integer,? extends Name> aliasFunction)
```
    Description copied from interface: Table
    Create an alias for this table and its fields.
    This works like Table.as(Name, Name...), except that field aliases are provided by a function. This is useful, for instance, to prefix all columns with a common prefix:
    
    MY_TABLE.as("t1", (f, i) ->"column" + i);
    Specified by:
    
    as in interface Table<R extends Record>
    
    Parameters:
    
    alias - The alias name
    
    aliasFunction - The function providing field aliases.
    
    Returns:
    
    The table alias
  - getType
```
public final TableOptions.TableType getType()
```
    Description copied from interface: Table
    
    Get the table type.
    
    Specified by:
    
    getType in interface Table<R extends Record>
  - getOptions
```
public final TableOptions getOptions()
```
    Description copied from interface: Table
    
    Get the table options.
    
    Specified by:
    
    getOptions in interface Table<R extends Record>
  - getCatalog
```
public final Catalog getCatalog()
```
    Description copied from interface: Qualified
    
    Get the object's catalog.
    
    Specified by:
    
    getCatalog in interface Qualified
  - getSchema
```
public Schema getSchema()
```
    Description copied from interface: Qualified
    
    Get the object's schema.
    
    Specified by:
    
    getSchema in interface Qualified
  - getIdentity
```
public Identity<R,?> getIdentity()
```
    Retrieve the table's IDENTITY information, if available.
    With SQL:2003, the concept of IDENTITY columns was introduced in most RDBMS. These are special kinds of columns that have auto-increment functionality when INSERT statements are performed.
    An IDENTITY column is usually part of the PRIMARY KEY or of a UNIQUE KEY in the table, although in some RDBMS, this is not required. There can only be at most one IDENTITY column.
    Note: Unfortunately, this is not supported in the Oracle dialect, where identities emulated by triggers cannot be formally detected.
    Subclasses should override this method
    
    Specified by:
    
    getIdentity in interface Table<R extends Record>
    
    Returns:
    
    The table's IDENTITY information, or null, if no such information is available.
  - getPrimaryKey
```
public UniqueKey<R> getPrimaryKey()
```
    Retrieve the table's primary key
    Subclasses may override this method
    
    Specified by:
    
    getPrimaryKey in interface Table<R extends Record>
    
    Returns:
    
    The primary key. This is never null for an updatable table.
  - getRecordVersion
```
public TableField<R,?> getRecordVersion()
```
    A "version" field holding record version information used for optimistic locking
    jOOQ supports optimistic locking in UpdatableRecord.store() and UpdatableRecord.delete() if Settings.isExecuteWithOptimisticLocking() is enabled. Optimistic locking is performed in a single UPDATE or DELETE statement if tables provide a "version" or "timestamp" field, or in two steps using an additional SELECT .. FOR UPDATE statement otherwise.
    This method is overridden in generated subclasses if their corresponding tables have been configured accordingly. A table may have both a "version" and a "timestamp" field.
    Subclasses may override this method
    
    Specified by:
    
    getRecordVersion in interface Table<R extends Record>
    
    Returns:
    
    The "version" field, or null, if this table has no "version" field.
    
    See Also:
    
    Table.getRecordTimestamp(), UpdatableRecord.store(), UpdatableRecord.delete(), Settings.isExecuteWithOptimisticLocking()
  - getRecordTimestamp
```
public TableField<R,?> getRecordTimestamp()
```
    A "timestamp" field holding record timestamp information used for optimistic locking
    jOOQ supports optimistic locking in UpdatableRecord.store() and UpdatableRecord.delete() if Settings.isExecuteWithOptimisticLocking() is enabled. Optimistic locking is performed in a single UPDATE or DELETE statement if tables provide a "version" or "timestamp" field, or in two steps using an additional SELECT .. FOR UPDATE statement otherwise.
    This method is overridden in generated subclasses if their corresponding tables have been configured accordingly. A table may have both a "version" and a "timestamp" field.
    Subclasses may override this method
    
    Specified by:
    
    getRecordTimestamp in interface Table<R extends Record>
    
    Returns:
    
    The "timestamp" field, or null, if this table has no "timestamp" field.
    
    See Also:
    
    Table.getRecordVersion(), UpdatableRecord.store(), UpdatableRecord.delete(), Settings.isExecuteWithOptimisticLocking()
  - getIndexes
```
public List<Index> getIndexes()
```
    Retrieve all of the table's indexes.
    Subclasses should override this method
    
    Specified by:
    
    getIndexes in interface Table<R extends Record>
    
    Returns:
    
    All indexes. This is never null. This method returns an unmodifiable list.
  - getKeys
```
public List<UniqueKey<R>> getKeys()
```
    Retrieve all of the table's unique keys.
    Subclasses should override this method
    
    Specified by:
    
    getKeys in interface Table<R extends Record>
    
    Returns:
    
    All keys. This is never null. This is never empty for a Table with a Table.getPrimaryKey(). This method returns an unmodifiable list.
  - getReferencesFrom
```
public final <O extends Record> List<ForeignKey<O,R>> getReferencesFrom(Table<O> other)
```
    Description copied from interface: Table
    
    Get a list of FOREIGN KEY's of a specific table, referencing a this table.
    This will recurse into joined tables.
    
    Specified by:
    
    getReferencesFrom in interface Table<R extends Record>
    
    Type Parameters:
    
    O - The other table's record type
    
    Parameters:
    
    other - The other table of the foreign key relationship
    
    Returns:
    
    Some other table's FOREIGN KEY's towards an this table. This is never null. This method returns an unmodifiable list.
  - getReferences
```
public List<ForeignKey<R,?>> getReferences()
```
    Get the list of FOREIGN KEY's of this table
    Subclasses should override this method
    
    Specified by:
    
    getReferences in interface Table<R extends Record>
    
    Returns:
    
    This table's FOREIGN KEY's. This is never null.
  - getReferencesTo
```
public final <O extends Record> List<ForeignKey<R,O>> getReferencesTo(Table<O> other)
```
    Description copied from interface: Table
    
    Get a list of FOREIGN KEY's of this table, referencing a specific table.
    This will recurse into joined tables.
    
    Specified by:
    
    getReferencesTo in interface Table<R extends Record>
    
    Type Parameters:
    
    O - The other table's record type
    
    Parameters:
    
    other - The other table of the foreign key relationship
    
    Returns:
    
    This table's FOREIGN KEY's towards an other table. This is never null.
  - getChecks
```
public List<Check<R>> getChecks()
```
    Get a list of CHECK constraints of this table.
    Subclasses should override this method
    
    Specified by:
    
    getChecks in interface Table<R extends Record>
  - createField
```
@Deprecated
protected static final <R extends Record,T> TableField<R,T> createField(String name,
                                                                                    DataType<T> type,
                                                                                    Table<R> table)
```
    Deprecated.
    - 3.12.0 - [#8000] - Use AbstractTable.createField(Name, DataType, Table) instead.
    
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
@Deprecated
protected static final <R extends Record,T> TableField<R,T> createField(String name,
                                                                                    DataType<T> type,
                                                                                    Table<R> table,
                                                                                    String comment)
```
    Deprecated.
    - 3.12.0 - [#8000] - Use AbstractTable.createField(Name, DataType, Table, String) instead.
    
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
@Deprecated
protected static final <R extends Record,T,U> TableField<R,U> createField(String name,
                                                                                            DataType<T> type,
                                                                                            Table<R> table,
                                                                                            String comment,
                                                                                            Converter<T,U> converter)
```
    Deprecated.
    - 3.12.0 - [#8000] - Use AbstractTable.createField(Name, DataType, Table, String, Converter) instead.
    
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
@Deprecated
protected static final <R extends Record,T,U> TableField<R,U> createField(String name,
                                                                                            DataType<T> type,
                                                                                            Table<R> table,
                                                                                            String comment,
                                                                                            Binding<T,U> binding)
```
    Deprecated.
    - 3.12.0 - [#8000] - Use AbstractTable.createField(Name, DataType, Table, String, Binding) instead.
    
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
@Deprecated
protected static final <R extends Record,T,X,U> TableField<R,U> createField(String name,
                                                                                                    DataType<T> type,
                                                                                                    Table<R> table,
                                                                                                    String comment,
                                                                                                    Converter<X,U> converter,
                                                                                                    Binding<T,X> binding)
```
    Deprecated.
    - 3.12.0 - [#8000] - Use AbstractTable.createField(Name, DataType, Table, String, Converter, Binding) instead.
    
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
@Deprecated
protected final <T> TableField<R,T> createField(String name,
                                                      DataType<T> type)
```
    Deprecated.
    - 3.12.0 - [#8000] - Use createField(Name, DataType) instead.
    
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
@Deprecated
protected final <T> TableField<R,T> createField(String name,
                                                      DataType<T> type,
                                                      String comment)
```
    Deprecated.
    - 3.12.0 - [#8000] - Use createField(Name, DataType, String) instead.
    
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
@Deprecated
protected final <T,U> TableField<R,U> createField(String name,
                                                              DataType<T> type,
                                                              String comment,
                                                              Converter<T,U> converter)
```
    Deprecated.
    - 3.12.0 - [#8000] - Use createField(Name, DataType, String, Converter) instead.
    
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
@Deprecated
protected final <T,U> TableField<R,U> createField(String name,
                                                              DataType<T> type,
                                                              String comment,
                                                              Binding<T,U> binding)
```
    Deprecated.
    - 3.12.0 - [#8000] - Use createField(Name, DataType, String, Binding) instead.
    
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
@Deprecated
protected final <T,X,U> TableField<R,U> createField(String name,
                                                                      DataType<T> type,
                                                                      String comment,
                                                                      Converter<X,U> converter,
                                                                      Binding<T,X> binding)
```
    Deprecated.
    - 3.12.0 - [#8000] - Use createField(Name, DataType, String, Converter, Binding) instead.
    
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
protected static final <R extends Record,T> TableField<R,T> createField(Name name,
                                                                                    DataType<T> type,
                                                                                    Table<R> table)
```
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
protected static final <R extends Record,T> TableField<R,T> createField(Name name,
                                                                                    DataType<T> type,
                                                                                    Table<R> table,
                                                                                    String comment)
```
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
protected static final <R extends Record,T,U> TableField<R,U> createField(Name name,
                                                                                            DataType<T> type,
                                                                                            Table<R> table,
                                                                                            String comment,
                                                                                            Converter<T,U> converter)
```
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
protected static final <R extends Record,T,U> TableField<R,U> createField(Name name,
                                                                                            DataType<T> type,
                                                                                            Table<R> table,
                                                                                            String comment,
                                                                                            Binding<T,U> binding)
```
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
protected static final <R extends Record,T,X,U> TableField<R,U> createField(Name name,
                                                                                                    DataType<T> type,
                                                                                                    Table<R> table,
                                                                                                    String comment,
                                                                                                    Converter<X,U> converter,
                                                                                                    Binding<T,X> binding)
```
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
protected final <T> TableField<R,T> createField(Name name,
                                                      DataType<T> type)
```
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
protected final <T> TableField<R,T> createField(Name name,
                                                      DataType<T> type,
                                                      String comment)
```
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
protected final <T,U> TableField<R,U> createField(Name name,
                                                              DataType<T> type,
                                                              String comment,
                                                              Converter<T,U> converter)
```
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
protected final <T,U> TableField<R,U> createField(Name name,
                                                              DataType<T> type,
                                                              String comment,
                                                              Binding<T,U> binding)
```
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - createField
```
protected final <T,X,U> TableField<R,U> createField(Name name,
                                                                      DataType<T> type,
                                                                      String comment,
                                                                      Converter<X,U> converter,
                                                                      Binding<T,X> binding)
```
    Subclasses may call this method to create TableField objects that are linked to this table.
    
    Parameters:
    
    name - The name of the field (case-sensitive!)
    
    type - The data type of the field
  - eq
```
public final Condition eq(Table<R> that)
```
    Description copied from interface: Table
    Create a predicate comparing records from self-joined tables.
    This is a convenience method for self-joins, comparing complete records between tables.
    For example:
    MyTable a = MY_TABLE.as("a"); MyTable b = MY_TABLE.as("b"); DSL.using(configuration) .select() .from(a) .join(b).on(a.eq(b));
    Specified by:
    
    eq in interface Table<R extends Record>
    
    See Also:
    
    Table.equal(Table)
  - equal
```
public final Condition equal(Table<R> that)
```
    Description copied from interface: Table
    Create a predicate comparing records from self-joined tables.
    This is a convenience method for self-joins, comparing complete records between tables.
    For example:
    MyTable a = MY_TABLE.as("a"); MyTable b = MY_TABLE.as("b"); DSL.using(configuration) .select() .from(a) .join(b).on(a.equal(b));
    Specified by:
    
    equal in interface Table<R extends Record>
  - ne
```
public final Condition ne(Table<R> that)
```
    Description copied from interface: Table
    Create a predicate comparing records from self-non-equi-joined tables. This is a convenience method for self-joins, comparing complete records between tables.
    For example:
    MyTable a = MY_TABLE.as("a"); MyTable b = MY_TABLE.as("b"); DSL.using(configuration) .select() .from(a) .join(b).on(a.ne(b));
    Specified by:
    
    ne in interface Table<R extends Record>
    
    See Also:
    
    Table.notEqual(Table)
  - notEqual
```
public final Condition notEqual(Table<R> that)
```
    Description copied from interface: Table
    Create a predicate comparing records from self-non-equi-joined tables.
    This is a convenience method for self-joins, comparing complete records between tables.
    For example:
    MyTable a = MY_TABLE.as("a"); MyTable b = MY_TABLE.as("b"); DSL.using(configuration) .select() .from(a) .join(b).on(a.notEqual(b));
    Specified by:
    
    notEqual in interface Table<R extends Record>
  - useIndex
```
public final Table<R> useIndex(String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
    
    create.select() .from(BOOK.as("b").useIndex("MY_INDEX") .fetch();
    Specified by:
    
    useIndex in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - useIndexForJoin
```
public final Table<R> useIndexForJoin(String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
    
    create.select() .from(BOOK.as("b").useIndexForJoin("MY_INDEX") .fetch();
    Specified by:
    
    useIndexForJoin in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - useIndexForOrderBy
```
public final Table<R> useIndexForOrderBy(String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
    
    create.select() .from(BOOK.as("b").useIndexForOrderBy("MY_INDEX") .fetch();
    Specified by:
    
    useIndexForOrderBy in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - useIndexForGroupBy
```
public final Table<R> useIndexForGroupBy(String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
    
    create.select() .from(BOOK.as("b").useIndexForGroupBy("MY_INDEX") .fetch();
    Specified by:
    
    useIndexForGroupBy in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - ignoreIndex
```
public final Table<R> ignoreIndex(String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
    
    create.select() .from(BOOK.as("b").useIndex("MY_INDEX") .fetch();
    Specified by:
    
    ignoreIndex in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - ignoreIndexForJoin
```
public final Table<R> ignoreIndexForJoin(String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
    
    create.select() .from(BOOK.as("b").useIndexForJoin("MY_INDEX") .fetch();
    Specified by:
    
    ignoreIndexForJoin in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - ignoreIndexForOrderBy
```
public final Table<R> ignoreIndexForOrderBy(String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
    
    create.select() .from(BOOK.as("b").useIndexForOrderBy("MY_INDEX") .fetch();
    Specified by:
    
    ignoreIndexForOrderBy in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - ignoreIndexForGroupBy
```
public final Table<R> ignoreIndexForGroupBy(String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
    
    create.select() .from(BOOK.as("b").useIndexForGroupBy("MY_INDEX") .fetch();
    Specified by:
    
    ignoreIndexForGroupBy in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - forceIndex
```
public final Table<R> forceIndex(String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
    
    create.select() .from(BOOK.as("b").useIndex("MY_INDEX") .fetch();
    Specified by:
    
    forceIndex in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - forceIndexForJoin
```
public final Table<R> forceIndexForJoin(String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
    
    create.select() .from(BOOK.as("b").useIndexForJoin("MY_INDEX") .fetch();
    Specified by:
    
    forceIndexForJoin in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - forceIndexForOrderBy
```
public final Table<R> forceIndexForOrderBy(String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
    
    create.select() .from(BOOK.as("b").useIndexForOrderBy("MY_INDEX") .fetch();
    Specified by:
    
    forceIndexForOrderBy in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - forceIndexForGroupBy
```
public final Table<R> forceIndexForGroupBy(String... indexes)
```
    Description copied from interface: Table
    Specify a MySQL style table hint for query optimisation.
    Example:
    
    create.select() .from(BOOK.as("b").useIndexForGroupBy("MY_INDEX") .fetch();
    Specified by:
    
    forceIndexForGroupBy in interface Table<R extends Record>
    
    See Also:
    
    http://dev.mysql.com/doc/refman/5.7/en/index-hints.html
  - as
```
public final Table<R> as(Table<?> otherTable)
```
    Description copied from interface: Table
    
    Create an alias for this table based on another table's name.
    
    Specified by:
    
    as in interface Table<R extends Record>
    
    Parameters:
    
    otherTable - The other table whose name this table is aliased with.
    
    Returns:
    
    The table alias.
  - as
```
public final Table<R> as(Table<?> otherTable,
                         Field<?>... otherFields)
```
    Description copied from interface: Table
    
    Create an alias for this table based on another table's name.
    
    Specified by:
    
    as in interface Table<R extends Record>
    
    Parameters:
    
    otherTable - The other table whose name this table is aliased with.
    
    otherFields - The other fields whose field name this table's fields are aliased with.
    
    Returns:
    
    The table alias.
  - as
```
public final Table<R> as(Table<?> otherTable,
                         Function<? super Field<?>,? extends Field<?>> aliasFunction)
```
    Description copied from interface: Table
    Create an alias for this table and its fields.
    This works like Table.as(Table, Field...), except that field aliases are provided by a function. This is useful, for instance, to prefix all columns with a common prefix:
    
    MY_TABLE.as(MY_OTHER_TABLE, f ->MY_OTHER_TABLE.field(f));
    Specified by:
    
    as in interface Table<R extends Record>
    
    Parameters:
    
    otherTable - The other table whose name is used as alias name
    
    aliasFunction - The function providing field aliases.
    
    Returns:
    
    The table alias
  - as
```
public final Table<R> as(Table<?> otherTable,
                         BiFunction<? super Field<?>,? super Integer,? extends Field<?>> aliasFunction)
```
    Description copied from interface: Table
    Create an alias for this table and its fields.
    This works like Table.as(Table, Field...), except that field aliases are provided by a function. This is useful, for instance, to prefix all columns with a common prefix:
    
    MY_TABLE.as("t1", (f, i) ->"column" + i);
    Specified by:
    
    as in interface Table<R extends Record>
    
    Parameters:
    
    otherTable - The other table whose name is used as alias name
    
    aliasFunction - The function providing field aliases.
    
    Returns:
    
    The table alias
  - with
```
@Pro
public final Table<R> with(String hint)
```
    Description copied from interface: Table
    Specify a SQL Server style table hint for query optimisation.
    This makes sense only on an actual database table or view, not on other composed table sources.
    Example:
    
    create.select() .from(BOOK.as("b").with("READUNCOMMITTED") .fetch();
    
    For SQLDialect.ORACLE style hints, see SelectFromStep.hint(String) and SelectQuery.addHint(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!
    Specified by:
    
    with in interface Table<R extends Record>
    
    See Also:
    
    http://msdn.microsoft.com/en-us/library/ms187373.aspx, SelectFromStep.hint(String), SelectQuery.addHint(String)
  - with
```
public final Table<R> with(String hint,
                           Object... binds)
```
    Description copied from interface: Table
    Specify a SQL Server style table hint for query optimisation.
    This makes sense only on an actual database table or view, not on other composed table sources.
    Example:
    
    create.select() .from(BOOK.as("b").with("READUNCOMMITTED") .fetch();
    
    For SQLDialect.ORACLE style hints, see SelectFromStep.hint(String) and SelectQuery.addHint(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!
    Specified by:
    
    with in interface Table<R extends Record>
    
    See Also:
    
    http://msdn.microsoft.com/en-us/library/ms187373.aspx, SelectFromStep.hint(String), SelectQuery.addHint(String)
  - with
```
public final Table<R> with(String hint,
                           QueryPart... parts)
```
    Description copied from interface: Table
    Specify a SQL Server style table hint for query optimisation.
    This makes sense only on an actual database table or view, not on other composed table sources.
    Example:
    
    create.select() .from(BOOK.as("b").with("READUNCOMMITTED") .fetch();
    
    For SQLDialect.ORACLE style hints, see SelectFromStep.hint(String) and SelectQuery.addHint(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!
    Specified by:
    
    with in interface Table<R extends Record>
    
    See Also:
    
    http://msdn.microsoft.com/en-us/library/ms187373.aspx, SelectFromStep.hint(String), SelectQuery.addHint(String)
  - with
```
public final Table<R> with(SQL hint)
```
    Description copied from interface: Table
    Specify a SQL Server style table hint for query optimisation.
    This makes sense only on an actual database table or view, not on other composed table sources.
    Example:
    
    create.select() .from(BOOK.as("b").with("READUNCOMMITTED") .fetch();
    
    For SQLDialect.ORACLE style hints, see SelectFromStep.hint(String) and SelectQuery.addHint(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!
    Specified by:
    
    with in interface Table<R extends Record>
    
    See Also:
    
    http://msdn.microsoft.com/en-us/library/ms187373.aspx, SelectFromStep.hint(String), SelectQuery.addHint(String)
  - at
```
@Pro
public final Table<R> at(String link)
```
    Description copied from interface: Table
    
    A table reference of this table at a given Link.
    
    Specified by:
    
    at in interface Table<R extends Record>
    
    See Also:
    
    DSL.link(String)
  - at
```
@Pro
public final Table<R> at(Name link)
```
    Description copied from interface: Table
    
    A table reference of this table at a given Link.
    
    Specified by:
    
    at in interface Table<R extends Record>
    
    See Also:
    
    DSL.link(Name)
  - at
```
@Pro
public final Table<R> at(Link link)
```
    Description copied from interface: Table
    
    A table reference of this table at a given Link.
    
    Specified by:
    
    at in interface Table<R extends Record>
  - pivot
```
@Pro
public final PivotForStep pivot(Field<?>... aggregateFunctions)
```
    Description copied from interface: Table
    Create a new TABLE reference from this table, pivoting it into another form.
    This has been observed to work with
    
    SQLDialect.ORACLE11G upwards
    
    SQLDialect.SQLSERVER (not yet officially supported)
    
    Other dialects by using some means of emulation (not yet officially supported)
    Specified by:
    
    pivot in interface Table<R extends Record>
    
    Parameters:
    
    aggregateFunctions - The aggregate functions used for pivoting.
    
    Returns:
    
    A DSL object to create the PIVOT expression
  - pivot
```
@Pro
public final PivotForStep pivot(Collection<? extends Field<?>> aggregateFunctions)
```
    Description copied from interface: Table
    
    Create a new TABLE reference from this table, pivoting it into another form.
    For more details, see Table.pivot(Field...)
    
    Specified by:
    
    pivot in interface Table<R extends Record>
    
    Parameters:
    
    aggregateFunctions - The aggregate functions used for pivoting.
    
    Returns:
    
    A DSL object to create the PIVOT expression
    
    See Also:
    
    Table.pivot(Field...)
  - for_
```
@Pro
public final Table<R> for_(PeriodSpecification periodSpecification)
```
    Description copied from interface: Table
    
    Create a reference to a temporal table with a PeriodSpecification for usage in Select.
    
    Specified by:
    
    for_ in interface Table<R extends Record>
  - forPortionOf
```
public final Table<R> forPortionOf(PeriodSpecification periodSpecification)
```
    Description copied from interface: Table
    
    Create a reference to a temporal table with a PeriodSpecification for usage in Update and Delete.
    
    Specified by:
    
    forPortionOf in interface Table<R extends Record>
  - versionsBetweenScn
```
@Pro
public final VersionsBetweenAndStep<R,Number> versionsBetweenScn(Number scn)
```
    Description copied from interface: Table
    
    Create an SQLDialect.ORACLE flashback versions query clause from this table.
    
    Specified by:
    
    versionsBetweenScn in interface Table<R extends Record>
  - versionsBetweenScn
```
@Pro
public final VersionsBetweenAndStep<R,Number> versionsBetweenScn(Field<? extends Number> scn)
```
    Description copied from interface: Table
    
    Create an SQLDialect.ORACLE flashback versions query clause from this table.
    
    Specified by:
    
    versionsBetweenScn in interface Table<R extends Record>
  - versionsBetweenScnMinvalue
```
@Pro
public final VersionsBetweenAndStep<R,Number> versionsBetweenScnMinvalue()
```
    Description copied from interface: Table
    
    Create an SQLDialect.ORACLE flashback versions query clause from this table.
    
    Specified by:
    
    versionsBetweenScnMinvalue in interface Table<R extends Record>
  - versionsBetweenTimestamp
```
@Pro
public final VersionsBetweenAndStep<R,Timestamp> versionsBetweenTimestamp(Timestamp timestamp)
```
    Description copied from interface: Table
    
    Create an SQLDialect.ORACLE flashback versions query clause from this table.
    
    Specified by:
    
    versionsBetweenTimestamp in interface Table<R extends Record>
  - versionsBetweenTimestamp
```
@Pro
public final VersionsBetweenAndStep<R,Timestamp> versionsBetweenTimestamp(Field<Timestamp> timestamp)
```
    Description copied from interface: Table
    
    Create an SQLDialect.ORACLE flashback versions query clause from this table.
    
    Specified by:
    
    versionsBetweenTimestamp in interface Table<R extends Record>
  - versionsBetweenTimestampMinvalue
```
@Pro
public final VersionsBetweenAndStep<R,Timestamp> versionsBetweenTimestampMinvalue()
```
    Description copied from interface: Table
    
    Create an SQLDialect.ORACLE flashback versions query clause from this table.
    
    Specified by:
    
    versionsBetweenTimestampMinvalue in interface Table<R extends Record>
  - asOfScn
```
@Pro
public final Table<R> asOfScn(Number scn)
```
    Description copied from interface: Table
    
    Create an SQLDialect.ORACLE flashback query clause from this table.
    
    Specified by:
    
    asOfScn in interface Table<R extends Record>
  - asOfScn
```
@Pro
public final Table<R> asOfScn(Field<? extends Number> scn)
```
    Description copied from interface: Table
    
    Create an SQLDialect.ORACLE flashback query clause from this table.
    
    Specified by:
    
    asOfScn in interface Table<R extends Record>
  - asOfTimestamp
```
@Pro
public final Table<R> asOfTimestamp(Timestamp timestamp)
```
    Description copied from interface: Table
    
    Create an SQLDialect.ORACLE flashback query clause from this table.
    
    Specified by:
    
    asOfTimestamp in interface Table<R extends Record>
  - asOfTimestamp
```
@Pro
public final Table<R> asOfTimestamp(Field<Timestamp> timestamp)
```
    Description copied from interface: Table
    
    Create an SQLDialect.ORACLE flashback query clause from this table.
    
    Specified by:
    
    asOfTimestamp in interface Table<R extends Record>
  - divideBy
```
public final DivideByOnStep divideBy(Table<?> divisor)
```
    Description copied from interface: Table
    Create a new TABLE reference from this table, applying relational division.
    Relational division is the inverse of a cross join operation. The following is an approximate definition of a relational division:
    Assume the following cross join / cartesian product C = A × B Then it can be said that A = C ÷ B B = C ÷ A
    
    With jOOQ, you can simplify using relational divisions by using the following syntax:
    C.divideBy(B).on(C.ID.equal(B.C_ID)).returning(C.TEXT)
    
    The above roughly translates to
    SELECT DISTINCT C.TEXT FROM C "c1" WHERE NOT EXISTS ( SELECT 1 FROM B WHERE NOT EXISTS ( SELECT 1 FROM C "c2" WHERE "c2".TEXT = "c1".TEXT AND "c2".ID = B.C_ID ) )
    
    Or in plain text: Find those TEXT values in C whose ID's correspond to all ID's in B. Note that from the above SQL statement, it is immediately clear that proper indexing is of the essence. Be sure to have indexes on all columns referenced from the on(...) and returning(...) clauses.
    For more information about relational division and some nice, real-life examples, see
    
    http ://en.wikipedia.org/wiki/Relational_algebra#Division
    
    http://www.simple-talk.com/sql/t-sql-programming/divided-we-stand-the- sql-of-relational-division/
    
    This has been observed to work with all dialects
    Specified by:
    
    divideBy in interface Table<R extends Record>
  - leftSemiJoin
```
public final TableOnStep<R> leftSemiJoin(TableLike<?> table)
```
    Description copied from interface: Table
    A synthetic LEFT SEMI JOIN clause that translates to an equivalent EXISTS 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 or SELECT or any other clause than ON.
    Specified by:
    
    leftSemiJoin in interface Table<R extends Record>
  - leftAntiJoin
```
public final TableOnStep<R> leftAntiJoin(TableLike<?> table)
```
    Description copied from interface: Table
    A synthetic LEFT ANTI JOIN clause that translates to an equivalent NOT 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 anti join, the right hand side of the left anti join operator is not projected, i.e. it cannot be accessed from WHERE or SELECT or any other clause than ON.
    Specified by:
    
    leftAntiJoin in interface Table<R extends Record>
  - where
```
public Table<R> where(Condition condition)
```
    Description copied from interface: Table
    
    Add a WHERE clause to the table, connecting them with each other with Operator.AND.
    The resulting table acts like a derived table that projects all of this table's columns and filters by the argument Condition. If syntactically reasonable, the derived table may be inlined to the query that selects from the resulting table.
    
    Specified by:
    
    where in interface Table<R extends Record>
  - where
```
public Table<R> where(Condition... conditions)
```
    Description copied from interface: Table
    
    Add a WHERE clause to the table, connecting them with each other with Operator.AND.
    The resulting table acts like a derived table that projects all of this table's columns and filters by the argument Condition. If syntactically reasonable, the derived table may be inlined to the query that selects from the resulting table.
    
    Specified by:
    
    where in interface Table<R extends Record>
  - where
```
public Table<R> where(Collection<? extends Condition> conditions)
```
    Description copied from interface: Table
    
    Add a WHERE clause to the table, connecting them with each other with Operator.AND.
    The resulting table acts like a derived table that projects all of this table's columns and filters by the argument Condition. If syntactically reasonable, the derived table may be inlined to the query that selects from the resulting table.
    
    Specified by:
    
    where in interface Table<R extends Record>
  - where
```
public Table<R> where(Field<Boolean> field)
```
    Description copied from interface: Table
    
    Add a WHERE clause to the table.
    The resulting table acts like a derived table that projects all of this table's columns and filters by the argument Condition. If syntactically reasonable, the derived table may be inlined to the query that selects from the resulting table.
    
    Specified by:
    
    where in interface Table<R extends Record>
  - where
```
public Table<R> where(SQL sql)
```
    Description copied from interface: Table
    
    Add a WHERE clause to the table.
    The resulting table acts like a derived table that projects all of this table's columns and filters by the argument Condition. If syntactically reasonable, the derived table may be inlined to the query that selects from the resulting 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!
    
    Specified by:
    
    where in interface Table<R extends Record>
    
    See Also:
    
    DSL.condition(SQL), SQL
  - where
```
public Table<R> where(String sql)
```
    Description copied from interface: Table
    
    Add a WHERE clause to the table.
    The resulting table acts like a derived table that projects all of this table's columns and filters by the argument Condition. If syntactically reasonable, the derived table may be inlined to the query that selects from the resulting 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!
    
    Specified by:
    
    where in interface Table<R extends Record>
    
    See Also:
    
    DSL.condition(String), SQL
  - where
```
public Table<R> where(String sql,
                      Object... bindings)
```
    Description copied from interface: Table
    
    Add a WHERE clause to the table.
    The resulting table acts like a derived table that projects all of this table's columns and filters by the argument Condition. If syntactically reasonable, the derived table may be inlined to the query that selects from the resulting 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!
    
    Specified by:
    
    where in interface Table<R extends Record>
    
    See Also:
    
    DSL.condition(String, Object...), DSL.sql(String, Object...), SQL
  - where
```
public Table<R> where(String sql,
                      QueryPart... parts)
```
    Description copied from interface: Table
    
    Add a WHERE clause to the table.
    The resulting table acts like a derived table that projects all of this table's columns and filters by the argument Condition. If syntactically reasonable, the derived table may be inlined to the query that selects from the resulting 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!
    
    Specified by:
    
    where in interface Table<R extends Record>
    
    See Also:
    
    DSL.condition(String, QueryPart...), DSL.sql(String, QueryPart...), SQL
  - whereExists
```
public Table<R> whereExists(Select<?> select)
```
    Description copied from interface: Table
    
    Add a WHERE EXISTS clause to the table.
    The resulting table acts like a derived table that projects all of this table's columns and filters by the argument Condition. If syntactically reasonable, the derived table may be inlined to the query that selects from the resulting table.
    
    Specified by:
    
    whereExists in interface Table<R extends Record>
  - whereNotExists
```
public Table<R> whereNotExists(Select<?> select)
```
    Description copied from interface: Table
    
    Add a WHERE NOT EXISTS clause to the table.
    The resulting table acts like a derived table that projects all of this table's columns and filters by the argument Condition. If syntactically reasonable, the derived table may be inlined to the query that selects from the resulting table.
    
    Specified by:
    
    whereNotExists in interface Table<R extends Record>
  - join
```
public final TableOptionalOnStep<Record> join(TableLike<?> table,
                                              JoinType type)
```
    Description copied from interface: Table
    
    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. If it is required but omitted, a DSL.trueCondition(), i.e. 1 = 1 condition will be rendered
    
    Specified by:
    
    join in interface Table<R extends Record>
  - join
```
public final TableOnStep<Record> join(TableLike<?> table)
```
    Description copied from interface: Table
    
    INNER JOIN a table to this table.
    A synonym for Table.innerJoin(TableLike).
    
    Specified by:
    
    join in interface Table<R extends Record>
    
    See Also:
    
    Table.innerJoin(TableLike)
  - join
```
public final TableOnStep<Record> join(SQL sql)
```
    Description copied from interface: Table
    
    INNER JOIN a table to this table.
    A synonym for Table.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!
    
    Specified by:
    
    join in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(SQL), Table.innerJoin(SQL), SQL
  - join
```
public final TableOnStep<Record> join(String sql)
```
    Description copied from interface: Table
    
    INNER JOIN a table to this table.
    A synonym for Table.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!
    
    Specified by:
    
    join in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String), Table.innerJoin(String), SQL
  - join
```
public final TableOnStep<Record> join(String sql,
                                      Object... bindings)
```
    Description copied from interface: Table
    
    INNER JOIN a table to this table.
    A synonym for Table.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!
    
    Specified by:
    
    join in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...), DSL.sql(String, Object...), Table.innerJoin(String, Object...), SQL
  - join
```
public final TableOnStep<Record> join(String sql,
                                      QueryPart... parts)
```
    Description copied from interface: Table
    
    INNER JOIN a table to this table.
    A synonym for Table.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!
    
    Specified by:
    
    join in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), Table.innerJoin(String, QueryPart...), SQL
  - join
```
public final TableOnStep<Record> join(Name name)
```
    Description copied from interface: Table
    
    INNER JOIN a table to this table.
    A synonym for Table.innerJoin(Name).
    
    Specified by:
    
    join in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(Name), Table.innerJoin(Name)
  - innerJoin
```
public final TableOnStep<Record> innerJoin(TableLike<?> table)
```
    Description copied from interface: Table
    
    INNER JOIN a table to this table.
    
    Specified by:
    
    innerJoin in interface Table<R extends Record>
  - innerJoin
```
public final TableOnStep<Record> innerJoin(SQL sql)
```
    Description copied from interface: Table
    
    INNER 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!
    
    Specified by:
    
    innerJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(SQL), SQL
  - innerJoin
```
public final TableOnStep<Record> innerJoin(String sql)
```
    Description copied from interface: Table
    
    INNER 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!
    
    Specified by:
    
    innerJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String), SQL
  - innerJoin
```
public final TableOnStep<Record> innerJoin(String sql,
                                           Object... bindings)
```
    Description copied from interface: Table
    
    INNER 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!
    
    Specified by:
    
    innerJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...), DSL.sql(String, Object...), SQL
  - innerJoin
```
public final TableOnStep<Record> innerJoin(String sql,
                                           QueryPart... parts)
```
    Description copied from interface: Table
    
    INNER 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!
    
    Specified by:
    
    innerJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), SQL
  - innerJoin
```
public final TableOnStep<Record> innerJoin(Name name)
```
    Description copied from interface: Table
    
    INNER JOIN a table to this table.
    
    Specified by:
    
    innerJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(Name)
  - partitionBy
```
@Pro
public TableOuterJoinStep<Record> partitionBy(Field<?>... fields)
```
    Description copied from interface: Table
    
    Add a PARTITION BY clause to the left hand side of the OUTER JOIN keywords
    
    Specified by:
    
    partitionBy in interface Table<R extends Record>
  - partitionBy
```
@Pro
public TableOuterJoinStep<Record> partitionBy(Collection<? extends Field<?>> fields)
```
    Description copied from interface: Table
    
    Add a PARTITION BY clause to the left hand side of the OUTER JOIN keywords
    
    Specified by:
    
    partitionBy in interface Table<R extends Record>
  - leftJoin
```
public final TablePartitionByStep<Record> leftJoin(TableLike<?> table)
```
    Description copied from interface: Table
    
    LEFT OUTER JOIN a table to this table.
    A synonym for Table.leftOuterJoin(TableLike).
    
    Specified by:
    
    leftJoin in interface Table<R extends Record>
    
    See Also:
    
    Table.leftOuterJoin(TableLike)
  - leftJoin
```
public final TablePartitionByStep<Record> leftJoin(SQL sql)
```
    Description copied from interface: Table
    
    LEFT OUTER JOIN a table to this table.
    A synonym for Table.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!
    
    Specified by:
    
    leftJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(SQL), Table.leftOuterJoin(SQL), SQL
  - leftJoin
```
public final TablePartitionByStep<Record> leftJoin(String sql)
```
    Description copied from interface: Table
    
    LEFT OUTER JOIN a table to this table.
    A synonym for Table.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!
    
    Specified by:
    
    leftJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String), Table.leftOuterJoin(String), SQL
  - leftJoin
```
public final TablePartitionByStep<Record> leftJoin(String sql,
                                                   Object... bindings)
```
    Description copied from interface: Table
    
    LEFT OUTER JOIN a table to this table.
    A synonym for Table.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!
    
    Specified by:
    
    leftJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...), DSL.sql(String, Object...), Table.leftOuterJoin(String, Object...), SQL
  - leftJoin
```
public final TablePartitionByStep<Record> leftJoin(String sql,
                                                   QueryPart... parts)
```
    Description copied from interface: Table
    
    LEFT OUTER JOIN a table to this table.
    A synonym for Table.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!
    
    Specified by:
    
    leftJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), Table.leftOuterJoin(String, QueryPart...), SQL
  - leftJoin
```
public final TablePartitionByStep<Record> leftJoin(Name name)
```
    Description copied from interface: Table
    
    LEFT OUTER JOIN a table to this table.
    A synonym for Table.leftOuterJoin(Name).
    
    Specified by:
    
    leftJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(Name), Table.leftOuterJoin(Name)
  - leftOuterJoin
```
public final TablePartitionByStep<Record> leftOuterJoin(TableLike<?> table)
```
    Description copied from interface: Table
    
    LEFT OUTER JOIN a table to this table.
    
    Specified by:
    
    leftOuterJoin in interface Table<R extends Record>
  - leftOuterJoin
```
public final TablePartitionByStep<Record> leftOuterJoin(SQL sql)
```
    Description copied from interface: Table
    
    LEFT OUTER 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!
    
    Specified by:
    
    leftOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(SQL), SQL
  - leftOuterJoin
```
public final TablePartitionByStep<Record> leftOuterJoin(String sql)
```
    Description copied from interface: Table
    
    LEFT OUTER 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!
    
    Specified by:
    
    leftOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String), SQL
  - leftOuterJoin
```
public final TablePartitionByStep<Record> leftOuterJoin(String sql,
                                                        Object... bindings)
```
    Description copied from interface: Table
    
    LEFT OUTER 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!
    
    Specified by:
    
    leftOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...), DSL.sql(String, Object...), SQL
  - leftOuterJoin
```
public final TablePartitionByStep<Record> leftOuterJoin(String sql,
                                                        QueryPart... parts)
```
    Description copied from interface: Table
    
    LEFT OUTER 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!
    
    Specified by:
    
    leftOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), SQL
  - leftOuterJoin
```
public final TablePartitionByStep<Record> leftOuterJoin(Name name)
```
    Description copied from interface: Table
    
    LEFT OUTER JOIN a table to this table.
    
    Specified by:
    
    leftOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(Name), SQL
  - rightJoin
```
public final TablePartitionByStep<Record> rightJoin(TableLike<?> table)
```
    Description copied from interface: Table
    
    RIGHT OUTER JOIN a table to this table.
    A synonym for Table.rightOuterJoin(TableLike).
    This is only possible where the underlying RDBMS supports it.
    
    Specified by:
    
    rightJoin in interface Table<R extends Record>
    
    See Also:
    
    Table.rightOuterJoin(TableLike)
  - rightJoin
```
public final TablePartitionByStep<Record> rightJoin(SQL sql)
```
    Description copied from interface: Table
    
    RIGHT OUTER JOIN a table to this table.
    A synonym for Table.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!
    
    Specified by:
    
    rightJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(SQL), Table.rightOuterJoin(SQL), SQL
  - rightJoin
```
public final TablePartitionByStep<Record> rightJoin(String sql)
```
    Description copied from interface: Table
    
    RIGHT OUTER JOIN a table to this table.
    A synonym for Table.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!
    
    Specified by:
    
    rightJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String), Table.rightOuterJoin(String), SQL
  - rightJoin
```
public final TablePartitionByStep<Record> rightJoin(String sql,
                                                    Object... bindings)
```
    Description copied from interface: Table
    
    RIGHT OUTER JOIN a table to this table.
    A synonym for Table.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!
    
    Specified by:
    
    rightJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...), DSL.sql(String, Object...), Table.rightOuterJoin(String, Object...), SQL
  - rightJoin
```
public final TablePartitionByStep<Record> rightJoin(String sql,
                                                    QueryPart... parts)
```
    Description copied from interface: Table
    
    RIGHT OUTER JOIN a table to this table.
    A synonym for Table.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!
    
    Specified by:
    
    rightJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), Table.rightOuterJoin(String, QueryPart...), SQL
  - rightJoin
```
public final TablePartitionByStep<Record> rightJoin(Name name)
```
    Description copied from interface: Table
    
    RIGHT OUTER JOIN a table to this table.
    A synonym for Table.rightOuterJoin(Name).
    This is only possible where the underlying RDBMS supports it
    
    Specified by:
    
    rightJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(Name), Table.rightOuterJoin(Name)
  - rightOuterJoin
```
public final TablePartitionByStep<Record> rightOuterJoin(TableLike<?> table)
```
    Description copied from interface: Table
    
    RIGHT OUTER JOIN a table to this table.
    This is only possible where the underlying RDBMS supports it
    
    Specified by:
    
    rightOuterJoin in interface Table<R extends Record>
  - rightOuterJoin
```
public final TablePartitionByStep<Record> rightOuterJoin(SQL sql)
```
    Description copied from interface: Table
    
    RIGHT OUTER JOIN a table to this table.
    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!
    
    Specified by:
    
    rightOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(SQL), SQL
  - rightOuterJoin
```
public final TablePartitionByStep<Record> rightOuterJoin(String sql)
```
    Description copied from interface: Table
    
    RIGHT OUTER JOIN a table to this table.
    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!
    
    Specified by:
    
    rightOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String), SQL
  - rightOuterJoin
```
public final TablePartitionByStep<Record> rightOuterJoin(String sql,
                                                         Object... bindings)
```
    Description copied from interface: Table
    
    RIGHT OUTER JOIN a table to this table.
    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!
    
    Specified by:
    
    rightOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...), DSL.sql(String, Object...), SQL
  - rightOuterJoin
```
public final TablePartitionByStep<Record> rightOuterJoin(String sql,
                                                         QueryPart... parts)
```
    Description copied from interface: Table
    
    RIGHT OUTER JOIN a table to this table.
    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!
    
    Specified by:
    
    rightOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), SQL
  - rightOuterJoin
```
public final TablePartitionByStep<Record> rightOuterJoin(Name name)
```
    Description copied from interface: Table
    
    RIGHT OUTER JOIN a table to this table.
    This is only possible where the underlying RDBMS supports it
    
    Specified by:
    
    rightOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(Name)
  - fullOuterJoin
```
public final TableOnStep<Record> fullOuterJoin(TableLike<?> table)
```
    Description copied from interface: Table
    
    FULL OUTER JOIN a table to this table.
    This is only possible where the underlying RDBMS supports it
    
    Specified by:
    
    fullOuterJoin in interface Table<R extends Record>
  - fullOuterJoin
```
public final TableOnStep<Record> fullOuterJoin(SQL sql)
```
    Description copied from interface: Table
    
    FULL OUTER JOIN a table to this table.
    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!
    
    Specified by:
    
    fullOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(SQL), SQL
  - fullOuterJoin
```
public final TableOnStep<Record> fullOuterJoin(String sql)
```
    Description copied from interface: Table
    
    FULL OUTER JOIN a table to this table.
    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!
    
    Specified by:
    
    fullOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String), SQL
  - fullOuterJoin
```
public final TableOnStep<Record> fullOuterJoin(String sql,
                                               Object... bindings)
```
    Description copied from interface: Table
    
    FULL OUTER JOIN a table to this table.
    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!
    
    Specified by:
    
    fullOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...), DSL.sql(String, Object...), SQL
  - fullOuterJoin
```
public final TableOnStep<Record> fullOuterJoin(String sql,
                                               QueryPart... parts)
```
    Description copied from interface: Table
    
    FULL OUTER JOIN a table to this table.
    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!
    
    Specified by:
    
    fullOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), SQL
  - fullOuterJoin
```
public final TableOnStep<Record> fullOuterJoin(Name name)
```
    Description copied from interface: Table
    
    FULL OUTER JOIN a table to this table.
    This is only possible where the underlying RDBMS supports it
    
    Specified by:
    
    fullOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(Name)
  - fullJoin
```
public final TableOnStep<Record> fullJoin(TableLike<?> table)
```
    Description copied from interface: Table
    
    FULL OUTER JOIN a table to this table.
    A synonym for Table.fullOuterJoin(TableLike).
    
    Specified by:
    
    fullJoin in interface Table<R extends Record>
  - fullJoin
```
public final TableOnStep<Record> fullJoin(SQL sql)
```
    Description copied from interface: Table
    
    FULL OUTER JOIN a table to this table.
    A synonym for Table.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!
    
    Specified by:
    
    fullJoin in interface Table<R extends Record>
  - fullJoin
```
public final TableOnStep<Record> fullJoin(String sql)
```
    Description copied from interface: Table
    
    FULL OUTER JOIN a table to this table.
    A synonym for Table.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!
    
    Specified by:
    
    fullJoin in interface Table<R extends Record>
  - fullJoin
```
public final TableOnStep<Record> fullJoin(String sql,
                                          Object... bindings)
```
    Description copied from interface: Table
    
    FULL OUTER JOIN a table to this table.
    A synonym for Table.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!
    
    Specified by:
    
    fullJoin in interface Table<R extends Record>
  - fullJoin
```
public final TableOnStep<Record> fullJoin(String sql,
                                          QueryPart... parts)
```
    Description copied from interface: Table
    
    FULL OUTER JOIN a table to this table.
    A synonym for Table.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!
    
    Specified by:
    
    fullJoin in interface Table<R extends Record>
  - fullJoin
```
public final TableOnStep<Record> fullJoin(Name name)
```
    Description copied from interface: Table
    
    FULL OUTER JOIN a table to this table.
    A synonym for Table.fullOuterJoin(Name).
    
    Specified by:
    
    fullJoin in interface Table<R extends Record>
  - crossJoin
```
public final Table<Record> crossJoin(TableLike<?> table)
```
    Description copied from interface: Table
    CROSS JOIN a table to this table.
    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
    Specified by:
    
    crossJoin in interface Table<R extends Record>
  - crossJoin
```
public final Table<Record> crossJoin(SQL sql)
```
    Description copied from interface: Table
    CROSS JOIN a table to this table.
    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!
    Specified by:
    
    crossJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(SQL), SQL
  - crossJoin
```
public final Table<Record> crossJoin(String sql)
```
    Description copied from interface: Table
    CROSS JOIN a table to this table.
    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!
    Specified by:
    
    crossJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String), SQL
  - crossJoin
```
public final Table<Record> crossJoin(String sql,
                                     Object... bindings)
```
    Description copied from interface: Table
    CROSS JOIN a table to this table.
    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!
    Specified by:
    
    crossJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...), DSL.sql(String, Object...), SQL
  - crossJoin
```
public final Table<Record> crossJoin(String sql,
                                     QueryPart... parts)
```
    Description copied from interface: Table
    CROSS JOIN a table to this table.
    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!
    Specified by:
    
    crossJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), SQL
  - crossJoin
```
public final Table<Record> crossJoin(Name name)
```
    Description copied from interface: Table
    CROSS JOIN a table to this table.
    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
    Specified by:
    
    crossJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(Name)
  - naturalJoin
```
public final Table<Record> naturalJoin(TableLike<?> table)
```
    Description copied from interface: Table
    
    NATURAL JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    
    Specified by:
    
    naturalJoin in interface Table<R extends Record>
  - naturalJoin
```
public final Table<Record> naturalJoin(SQL sql)
```
    Description copied from interface: Table
    
    NATURAL JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    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!
    
    Specified by:
    
    naturalJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(SQL), SQL
  - naturalJoin
```
public final Table<Record> naturalJoin(String sql)
```
    Description copied from interface: Table
    
    NATURAL JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    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!
    
    Specified by:
    
    naturalJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String), SQL
  - naturalJoin
```
public final Table<Record> naturalJoin(String sql,
                                       Object... bindings)
```
    Description copied from interface: Table
    
    NATURAL JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    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!
    
    Specified by:
    
    naturalJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...), DSL.sql(String, Object...), SQL
  - naturalJoin
```
public final Table<Record> naturalJoin(String sql,
                                       QueryPart... parts)
```
    Description copied from interface: Table
    
    NATURAL JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    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!
    
    Specified by:
    
    naturalJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), SQL
  - naturalJoin
```
public final Table<Record> naturalJoin(Name name)
```
    Description copied from interface: Table
    
    NATURAL JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    
    Specified by:
    
    naturalJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(Name)
  - naturalLeftOuterJoin
```
public final Table<Record> naturalLeftOuterJoin(TableLike<?> table)
```
    Description copied from interface: Table
    
    NATURAL LEFT OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    
    Specified by:
    
    naturalLeftOuterJoin in interface Table<R extends Record>
  - naturalLeftOuterJoin
```
public final Table<Record> naturalLeftOuterJoin(SQL sql)
```
    Description copied from interface: Table
    
    NATURAL LEFT OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    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!
    
    Specified by:
    
    naturalLeftOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(SQL), SQL
  - naturalLeftOuterJoin
```
public final Table<Record> naturalLeftOuterJoin(String sql)
```
    Description copied from interface: Table
    
    NATURAL LEFT OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    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!
    
    Specified by:
    
    naturalLeftOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String), SQL
  - naturalLeftOuterJoin
```
public final Table<Record> naturalLeftOuterJoin(String sql,
                                                Object... bindings)
```
    Description copied from interface: Table
    
    NATURAL LEFT OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    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!
    
    Specified by:
    
    naturalLeftOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...), DSL.sql(String, Object...), SQL
  - naturalLeftOuterJoin
```
public final Table<Record> naturalLeftOuterJoin(String sql,
                                                QueryPart... parts)
```
    Description copied from interface: Table
    
    NATURAL LEFT OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    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!
    
    Specified by:
    
    naturalLeftOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), SQL
  - naturalLeftOuterJoin
```
public final Table<Record> naturalLeftOuterJoin(Name name)
```
    Description copied from interface: Table
    
    NATURAL LEFT OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    
    Specified by:
    
    naturalLeftOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(Name)
  - naturalRightOuterJoin
```
public final Table<Record> naturalRightOuterJoin(TableLike<?> table)
```
    Description copied from interface: Table
    
    NATURAL RIGHT OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    
    Specified by:
    
    naturalRightOuterJoin in interface Table<R extends Record>
  - naturalRightOuterJoin
```
public final Table<Record> naturalRightOuterJoin(SQL sql)
```
    Description copied from interface: Table
    
    NATURAL RIGHT OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    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!
    
    Specified by:
    
    naturalRightOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(SQL), SQL
  - naturalRightOuterJoin
```
public final Table<Record> naturalRightOuterJoin(String sql)
```
    Description copied from interface: Table
    
    NATURAL RIGHT OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    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!
    
    Specified by:
    
    naturalRightOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String), SQL
  - naturalRightOuterJoin
```
public final Table<Record> naturalRightOuterJoin(String sql,
                                                 Object... bindings)
```
    Description copied from interface: Table
    
    NATURAL RIGHT OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    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!
    
    Specified by:
    
    naturalRightOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...), DSL.sql(String, Object...), SQL
  - naturalRightOuterJoin
```
public final Table<Record> naturalRightOuterJoin(String sql,
                                                 QueryPart... parts)
```
    Description copied from interface: Table
    
    NATURAL RIGHT OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    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!
    
    Specified by:
    
    naturalRightOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), SQL
  - naturalRightOuterJoin
```
public final Table<Record> naturalRightOuterJoin(Name name)
```
    Description copied from interface: Table
    
    NATURAL RIGHT OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    
    Specified by:
    
    naturalRightOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(Name)
  - naturalFullOuterJoin
```
public final Table<Record> naturalFullOuterJoin(TableLike<?> table)
```
    Description copied from interface: Table
    
    NATURAL FULL OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    
    Specified by:
    
    naturalFullOuterJoin in interface Table<R extends Record>
  - naturalFullOuterJoin
```
public final Table<Record> naturalFullOuterJoin(SQL sql)
```
    Description copied from interface: Table
    
    NATURAL FULL OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    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!
    
    Specified by:
    
    naturalFullOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(SQL), SQL
  - naturalFullOuterJoin
```
public final Table<Record> naturalFullOuterJoin(String sql)
```
    Description copied from interface: Table
    
    NATURAL FULL OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    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!
    
    Specified by:
    
    naturalFullOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String), SQL
  - naturalFullOuterJoin
```
public final Table<Record> naturalFullOuterJoin(String sql,
                                                Object... bindings)
```
    Description copied from interface: Table
    
    NATURAL FULL OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    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!
    
    Specified by:
    
    naturalFullOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...), DSL.sql(String, Object...), SQL
  - naturalFullOuterJoin
```
public final Table<Record> naturalFullOuterJoin(String sql,
                                                QueryPart... parts)
```
    Description copied from interface: Table
    
    NATURAL FULL OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    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!
    
    Specified by:
    
    naturalFullOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), SQL
  - naturalFullOuterJoin
```
public final Table<Record> naturalFullOuterJoin(Name name)
```
    Description copied from interface: Table
    
    NATURAL FULL OUTER JOIN a table to this table.
    If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
    
    Specified by:
    
    naturalFullOuterJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(Name)
  - crossApply
```
public final Table<Record> crossApply(TableLike<?> table)
```
    Description copied from interface: Table
    
    CROSS APPLY a table to this table.
    
    Specified by:
    
    crossApply in interface Table<R extends Record>
  - crossApply
```
public final Table<Record> crossApply(SQL sql)
```
    Description copied from interface: Table
    
    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!
    
    Specified by:
    
    crossApply in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(SQL), SQL
  - crossApply
```
public final Table<Record> crossApply(String sql)
```
    Description copied from interface: Table
    
    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!
    
    Specified by:
    
    crossApply in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String), SQL
  - crossApply
```
public final Table<Record> crossApply(String sql,
                                      Object... bindings)
```
    Description copied from interface: Table
    
    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!
    
    Specified by:
    
    crossApply in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...), DSL.sql(String, Object...), SQL
  - crossApply
```
public final Table<Record> crossApply(String sql,
                                      QueryPart... parts)
```
    Description copied from interface: Table
    
    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!
    
    Specified by:
    
    crossApply in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), SQL
  - crossApply
```
public final Table<Record> crossApply(Name name)
```
    Description copied from interface: Table
    
    CROSS APPLY a table to this table.
    
    Specified by:
    
    crossApply in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(Name)
  - outerApply
```
public final Table<Record> outerApply(TableLike<?> table)
```
    Description copied from interface: Table
    
    OUTER APPLY a table to this table.
    
    Specified by:
    
    outerApply in interface Table<R extends Record>
  - outerApply
```
public final Table<Record> outerApply(SQL sql)
```
    Description copied from interface: Table
    
    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!
    
    Specified by:
    
    outerApply in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(SQL), SQL
  - outerApply
```
public final Table<Record> outerApply(String sql)
```
    Description copied from interface: Table
    
    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!
    
    Specified by:
    
    outerApply in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String), SQL
  - outerApply
```
public final Table<Record> outerApply(String sql,
                                      Object... bindings)
```
    Description copied from interface: Table
    
    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!
    
    Specified by:
    
    outerApply in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...), DSL.sql(String, Object...), SQL
  - outerApply
```
public final Table<Record> outerApply(String sql,
                                      QueryPart... parts)
```
    Description copied from interface: Table
    
    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!
    
    Specified by:
    
    outerApply in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), SQL
  - outerApply
```
public final Table<Record> outerApply(Name name)
```
    Description copied from interface: Table
    
    OUTER APPLY a table to this table.
    
    Specified by:
    
    outerApply in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(Name)
  - straightJoin
```
public final TableOptionalOnStep<Record> straightJoin(TableLike<?> table)
```
    Description copied from interface: Table
    
    STRAIGHT_JOIN a table to this table.
    
    Specified by:
    
    straightJoin in interface Table<R extends Record>
  - straightJoin
```
public final TableOptionalOnStep<Record> straightJoin(SQL sql)
```
    Description copied from interface: Table
    
    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!
    
    Specified by:
    
    straightJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(SQL), SQL
  - straightJoin
```
public final TableOptionalOnStep<Record> straightJoin(String sql)
```
    Description copied from interface: Table
    
    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!
    
    Specified by:
    
    straightJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String), SQL
  - straightJoin
```
public final TableOptionalOnStep<Record> straightJoin(String sql,
                                                      Object... bindings)
```
    Description copied from interface: Table
    
    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!
    
    Specified by:
    
    straightJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, Object...), DSL.sql(String, Object...), SQL
  - straightJoin
```
public final TableOptionalOnStep<Record> straightJoin(String sql,
                                                      QueryPart... parts)
```
    Description copied from interface: Table
    
    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!
    
    Specified by:
    
    straightJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), SQL
  - straightJoin
```
public final TableOptionalOnStep<Record> straightJoin(Name name)
```
    Description copied from interface: Table
    
    STRAIGHT_JOIN a table to this table.
    
    Specified by:
    
    straightJoin in interface Table<R extends Record>
    
    See Also:
    
    DSL.table(Name)
  - getName
```
public final String getName()
```
    Description copied from interface: Named
    
    The unqualified name of this object.
    
    Specified by:
    
    getName in interface Named
  - getQualifiedName
```
public Name getQualifiedName()
```
    Description copied from interface: Named
    
    The qualified name of this object.
    
    Specified by:
    
    getQualifiedName in interface Named
  - getUnqualifiedName
```
public final Name getUnqualifiedName()
```
    Description copied from interface: Named
    
    The unqualified name of this object.
    
    Specified by:
    
    getUnqualifiedName in interface Named
  - getComment
```
public final String getComment()
```
    Description copied from interface: Named
    
    The comment on this object.
    This is the same as calling Named.getCommentPart() and then Comment.getComment().
    
    Specified by:
    
    getComment in interface Named
  - getCommentPart
```
public final Comment getCommentPart()
```
    Description copied from interface: Named
    
    The comment on this object as a QueryPart.
    
    Specified by:
    
    getCommentPart in interface Named
  - hashCode
```
public int hashCode()
```
    Description copied from interface: QueryPart
    
    Generate a hash code from this QueryPart.
    In general, QueryPart hash codes are the same as the hash codes generated from QueryPart.toString(). This guarantees consistent behaviour with QueryPart.equals(Object)
    Some QueryPart implementations may choose to override this behaviour for improved performance, as QueryPart.toString() is an expensive operation, if called many times.
    
    Specified by:
    
    hashCode in interface QueryPart
    
    Returns:
    
    The QueryPart hash code
  - toSQL
```
@Deprecated
public final void toSQL(RenderContext context)
```
    Deprecated.
    - 3.4.0 - [#2694] - Use QueryPartInternal.accept(Context) instead.
    
    Description copied from interface: QueryPartInternal
    
    Render this QueryPart to a SQL string contained in context.sql(). The context will contain additional information about how to render this QueryPart, e.g. whether this QueryPart should be rendered as a declaration or reference, whether this QueryPart's contained bind variables should be inlined or replaced by '?', etc.
    
    Specified by:
    
    toSQL in interface QueryPartInternal
  - bind
```
@Deprecated
public final void bind(BindContext context)
                throws DataAccessException
```
    Deprecated.
    - 3.4.0 - [#2694] - Use QueryPartInternal.accept(Context) instead.
    
    Description copied from interface: QueryPartInternal
    
    Bind all parameters of this QueryPart to a PreparedStatement
    This method is for JOOQ INTERNAL USE only. Do not reference directly
    
    Specified by:
    
    bind in interface QueryPartInternal
    
    Parameters:
    
    context - The context holding the next bind index and other information for variable binding
    
    Throws:
    
    DataAccessException - If something went wrong while binding a variable
  - rendersContent
```
public boolean rendersContent(Context<?> ctx)
```
    Subclasses may override this
    
    Specified by:
    
    rendersContent in interface QueryPartInternal
  - declaresFields
```
public boolean declaresFields()
```
    Subclasses may override this
    
    Specified by:
    
    declaresFields in interface QueryPartInternal
  - declaresWindows
```
public boolean declaresWindows()
```
    Subclasses may override this
    
    Specified by:
    
    declaresWindows in interface QueryPartInternal
  - declaresCTE
```
public boolean declaresCTE()
```
    Subclasses may override this
    
    Specified by:
    
    declaresCTE in interface QueryPartInternal
  - generatesCast
```
public boolean generatesCast()
```
    Subclasses may override this
    
    Specified by:
    
    generatesCast in interface QueryPartInternal
  - toString
```
public String toString()
```
    Description copied from interface: QueryPart
    
    Render a SQL string representation of this QueryPart.
    For improved debugging, this renders a SQL string of this QueryPart with inlined bind variables. If this QueryPart is Attachable, then the attached Configuration may be used for rendering the SQL string, including SQLDialect and Settings. Do note that most QueryPart instances are not attached to a Configuration, and thus there is no guarantee that the SQL string will make sense in the context of a specific database.
    
    Specified by:
    
    toString in interface QueryPart
    
    Overrides:
    
    toString in class Object
    
    Returns:
    
    A SQL string representation of this QueryPart
  - create
```
@Deprecated
protected final DSLContext create()
```
    Deprecated.
    - 3.11.0 - [#6722] - Use Attachable.configuration() and Configuration.dsl() instead.
    
    Internal convenience method
  - create
```
@Deprecated
protected final DSLContext create(Configuration configuration)
```
    Deprecated.
    - 3.11.0 - [#6722] - Use Attachable.configuration() and Configuration.dsl() instead.
    
    Internal convenience method
  - create
```
@Deprecated
protected final DSLContext create(Context<?> ctx)
```
    Deprecated.
    - 3.11.0 - [#6722] - Use Attachable.configuration() and Configuration.dsl() instead.
    
    Internal convenience method
  - translate
```
protected final DataAccessException translate(String sql,
                                              SQLException e)
```
    Internal convenience method

Class TableImpl<R extends Record>

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Methods inherited from interface org.jooq.Named

Methods inherited from interface org.jooq.QueryPart

Field Detail

parameters

Constructor Detail

TableImpl

TableImpl

TableImpl

TableImpl

TableImpl

TableImpl

TableImpl

TableImpl

TableImpl

TableImpl

TableImpl

TableImpl

TableImpl

TableImpl

TableImpl

Method Detail

aliased

fieldsRow

clauses

accept

as

as

Derived column lists for table references

Derived column lists for derived tables

rename

rename

getRecordType

declaresTables

equals

from

asterisk

rowid

getDataType

recordType

newRecord

fieldStream

field

field

field

field

field

field

field

field

field

field

fields

fields

fields

fields

fields

indexOf

indexOf

indexOf

asTable

asTable

asTable

asTable

asTable

asTable

asTable

asTable

asTable

as

as

Derived column lists for table references

Derived column lists for derived tables

as

as

as