Top Description Inners Fields Constructors Methods
org.jooq.impl

pack-priv abstract Class JoinTable<J extends org.jooq.impl.JoinTable<J>>

extends AbstractTable<Record>
implements TableOuterJoinStep<Record>, TableOptionalOnStep<Record>, TablePartitionByStep<Record>, TableOnConditionStep<Record>
Class Inheritance
All Implemented Interfaces
org.jooq.TableOnConditionStep, org.jooq.Table, org.jooq.SelectField, org.jooq.Typed, org.jooq.QueryPart, java.io.Serializable, org.jooq.Named, org.jooq.SelectFieldOrAsterisk, org.jooq.GroupField, org.jooq.RecordQualifier, org.jooq.Fields, org.jooq.Qualified, org.jooq.TableLike, org.jooq.TablePartitionByStep, org.jooq.TableOnStep, org.jooq.TableOptionalOnStep, org.jooq.TableOuterJoinStep
Known Direct Subclasses
org.jooq.impl.CrossApply, org.jooq.impl.CrossJoin, org.jooq.impl.OuterApply, org.jooq.impl.FullJoin, org.jooq.impl.LeftAntiJoin, org.jooq.impl.LeftJoin, org.jooq.impl.LeftSemiJoin, org.jooq.impl.RightJoin, org.jooq.impl.NaturalFullJoin, org.jooq.impl.NaturalJoin, org.jooq.impl.NaturalLeftJoin, org.jooq.impl.NaturalRightJoin, org.jooq.impl.StraightJoin, org.jooq.impl.Join
Static Imports
java.lang.Boolean.TRUE, java.util.Arrays.asList, .Collections.emptyList, org.jooq.Clause.TABLE, .Clause.TABLE_JOIN, .Clause.TABLE_JOIN_ANTI_LEFT, .Clause.TABLE_JOIN_CROSS, .Clause.TABLE_JOIN_CROSS_APPLY, .Clause.TABLE_JOIN_INNER, .Clause.TABLE_JOIN_NATURAL, .Clause.TABLE_JOIN_NATURAL_OUTER_FULL, .Clause.TABLE_JOIN_NATURAL_OUTER_LEFT, .Clause.TABLE_JOIN_NATURAL_OUTER_RIGHT, .Clause.TABLE_JOIN_ON, .Clause.TABLE_JOIN_OUTER_APPLY, .Clause.TABLE_JOIN_OUTER_FULL, .Clause.TABLE_JOIN_OUTER_LEFT, .Clause.TABLE_JOIN_OUTER_RIGHT, .Clause.TABLE_JOIN_PARTITION_BY, .Clause.TABLE_JOIN_SEMI_LEFT, .Clause.TABLE_JOIN_STRAIGHT, .Clause.TABLE_JOIN_USING, .JoinType.CROSS_APPLY, .JoinType.CROSS_JOIN, .JoinType.FULL_OUTER_JOIN, .JoinType.JOIN, .JoinType.LEFT_ANTI_JOIN, .JoinType.LEFT_OUTER_JOIN, .JoinType.LEFT_SEMI_JOIN, .JoinType.NATURAL_FULL_OUTER_JOIN, .JoinType.NATURAL_JOIN, .JoinType.NATURAL_LEFT_OUTER_JOIN, .JoinType.NATURAL_RIGHT_OUTER_JOIN, .JoinType.OUTER_APPLY, .JoinType.RIGHT_OUTER_JOIN, .SQLDialect.CUBRID, .SQLDialect.FIREBIRD, .SQLDialect.H2, .SQLDialect.IGNITE, .SQLDialect.POSTGRES, .SQLDialect.YUGABYTEDB, org.jooq.impl.DSL.condition, .DSL.exists, .DSL.noCondition, .DSL.notExists, .DSL.selectOne, .DSL.trueCondition, .Keywords.K_CROSS_JOIN_LATERAL, .Keywords.K_LEFT_JOIN_LATERAL, .Keywords.K_LEFT_OUTER_JOIN_LATERAL, .Keywords.K_ON, .Keywords.K_PARTITION_BY, .Keywords.K_USING, .Names.N_JOIN, .QueryPartListView.wrap, .Tools.containsTable, .Tools.containsUnaliasedTable, .Tools.map, .Tools.visitAutoAliased, .Tools.BooleanDataKey.DATA_COLLECT_SEMI_ANTI_JOIN, .Tools.SimpleDataKey.DATA_COLLECTED_SEMI_ANTI_JOIN
A table consisting of two joined tables and possibly a join condition
Author
Lukas Eder

Nested and Inner Type Summary

Modifier and TypeClass and Description
private static enum
JoinTable.OnKeyExceptionReason

Field Summary

Modifier and TypeField and Description
pack-priv static final Clause[]
CLAUSES

Hides org.jooq.impl.AbstractTable.CLAUSES.

Deprecated as a consequence of Clause being deprecated.
pack-priv final ConditionProviderImpl
condition

Deprecated as a consequence of ConditionProviderImpl being deprecated.
pack-priv static final Set<SQLDialect>
EMULATE_APPLY

pack-priv static final Set<SQLDialect>
EMULATE_JOIN_USING

pack-priv static final Set<SQLDialect>
EMULATE_NATURAL_JOIN

pack-priv static final Set<SQLDialect>
EMULATE_NATURAL_OUTER_JOIN

pack-priv final Table<?>
lhs

pack-priv final QueryPartList<Field<?>>
lhsPartitionBy

pack-priv final Table<?>
rhs

pack-priv final QueryPartList<Field<?>>
rhsPartitionBy

pack-priv final JoinType
type

pack-priv final QueryPartList<Field<?>>
using

Constructor Summary

AccessConstructor and Description
pack-priv
JoinTable(TableLike<?> lhs, TableLike<?> rhs, JoinType type)

pack-priv
JoinTable(TableLike<?> lhs, TableLike<?> rhs, JoinType type, Collection<? extends Field<?>> lhsPartitionBy)

Method Summary

Modifier and TypeMethod and Description
public final Condition
$on()

Deprecated as a consequence of Condition being deprecated.
public final J
$on(Condition o)

Deprecated as a consequence of Condition being deprecated.
public final QOM.UnmodifiableList<Field<?>>
$partitionBy1()

public final J
$partitionBy1(Collection<? extends Field<?>> p1)

public final QOM.UnmodifiableList<Field<?>>
$partitionBy2()

public final J
$partitionBy2(Collection<? extends Field<?>> p2)

public final Table<?>
$table1()

public final J
$table1(Table<?> t1)

public final Table<?>
$table2()

public final J
$table2(Table<?> t2)

public final QOM.UnmodifiableList<Field<?>>
$using()

public final J
$using(Collection<? extends Field<?>> u)

public final void
accept(Context<?> ctx)

Implements org.jooq.QueryPartInternal.accept.

This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.
private final void
accept0(Context<?> ctx)

public final J
and(Condition c)

Implements org.jooq.TableOnConditionStep.and.

Deprecated as a consequence of Condition being deprecated.
Combine the currently assembled conditions with another one using the Operator#AND operator.
public final J
and(Field<Boolean> c)

Implements org.jooq.TableOnConditionStep.and.

Deprecated as a consequence of Field being deprecated.
Combine the currently assembled conditions with another one using the Operator#AND operator.
public final J
and(SQL sql)

Implements org.jooq.TableOnConditionStep.and.

Combine the currently assembled conditions with another one using the Operator#AND operator.
public final J
and(String sql)

Implements org.jooq.TableOnConditionStep.and.

Combine the currently assembled conditions with another one using the Operator#AND operator.
public final J
and(String sql, Object... bindings)

Implements org.jooq.TableOnConditionStep.and.

Combine the currently assembled conditions with another one using the Operator#AND operator.
public final J
and(String sql, QueryPart... parts)

Implements org.jooq.TableOnConditionStep.and.

Combine the currently assembled conditions with another one using the Operator#AND operator.
public final J
andExists(Select<?> select)

Implements org.jooq.TableOnConditionStep.andExists.

Combine the currently assembled conditions with an EXISTS clause using the Operator#AND operator.
public final J
andNot(Condition c)

Implements org.jooq.TableOnConditionStep.andNot.

Deprecated as a consequence of Condition being deprecated.
Combine the currently assembled conditions with a negated other one using the Operator#AND operator.
public final J
andNot(Field<Boolean> c)

Implements org.jooq.TableOnConditionStep.andNot.

Deprecated as a consequence of Field being deprecated.
Combine the currently assembled conditions with a negated other one using the Operator#AND operator.
public final J
andNotExists(Select<?> select)

Implements org.jooq.TableOnConditionStep.andNotExists.

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator#AND operator.
public final Table<Record>
as(Name
The alias name
alias)

Overrides org.jooq.impl.AbstractTable.as.

Implements org.jooq.Table.as.

Create an alias for this table.
public final Table<Record>
as(Name
The alias name
alias, Name...
The field aliases. Excess aliases are ignored, missing aliases will be substituted by this table's field names.
fieldAliases)

Overrides org.jooq.impl.AbstractTable.as.

Implements org.jooq.Table.as.

Create an alias for this table and its fields.
public final Clause[]
clauses(Context<?> ctx)

Overrides org.jooq.impl.AbstractTable.clauses.

Implements org.jooq.QueryPartInternal.clauses.

Deprecated as a consequence of Clause being deprecated.
The Clauses that are represented by this query part.
pack-priv abstract J
construct(Table<?> table1, Collection<? extends Field<?>> partitionBy1, Collection<? extends Field<?>> partitionBy2, Table<?> table2, Condition on, Collection<? extends Field<?>> using)

Deprecated as a consequence of Condition being deprecated.
public final boolean
declaresTables()

Overrides org.jooq.impl.AbstractQueryPart.declaresTables.

Implements org.jooq.QueryPartInternal.declaresTables.

Subclasses may override this
private final boolean
emulateCrossJoin(Context<?> ctx)

private final boolean
emulateNaturalFullOuterJoin(Context<?> ctx)

private final boolean
emulateNaturalJoin(Context<?> ctx)

private final boolean
emulateNaturalLeftOuterJoin(Context<?> ctx)

private final boolean
emulateNaturalRightOuterJoin(Context<?> ctx)

pack-priv final FieldsImpl<Record>
fields0()

Implements abstract org.jooq.impl.AbstractTable.fields0.

Subclasses should override this method to provide the set of fields contained in the concrete table implementation.
public final Class<? extends Record>
getRecordType()

Implements org.jooq.RecordQualifier.getRecordType.

The record type produced by this UDT or Table.
public final List<ForeignKey<Record, ?>>
getReferences()

Overrides org.jooq.impl.AbstractTable.getReferences.

Implements org.jooq.Table.getReferences.

Get the list of FOREIGN KEY's of this table
public final J
join(TableLike<?> table, JoinType type)

Overrides org.jooq.impl.AbstractTable.join.

Implements org.jooq.Table.join.

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.

pack-priv final Condition
naturalCondition()

Deprecated as a consequence of Condition being deprecated.
public final J
on(Condition conditions)

Implements org.jooq.TableOnStep.on.

Deprecated as a consequence of Condition being deprecated.
Add an ON clause to the JOIN, connecting them with each other with Operator#AND.
public final J
on(Condition... conditions)

Implements org.jooq.TableOnStep.on.

Deprecated as a consequence of Condition being deprecated.
Add an ON clause to the JOIN, connecting them with each other with Operator#AND.
public final J
on(Field<Boolean> c)

Implements org.jooq.TableOnStep.on.

Deprecated as a consequence of Field being deprecated.
Add an ON clause to the JOIN.
public final J
on(SQL sql)

Implements org.jooq.TableOnStep.on.

Add an ON clause to the JOIN.
public final J
on(String sql)

Implements org.jooq.TableOnStep.on.

Add an ON clause to the JOIN.
public final J
on(String sql, Object... bindings)

Implements org.jooq.TableOnStep.on.

Add an ON clause to the JOIN.
public final J
on(String sql, QueryPart... parts)

Implements org.jooq.TableOnStep.on.

Add an ON clause to the JOIN.
public final J
onKey()

Implements org.jooq.TableOnStep.onKey.

Join the table on a non-ambiguous foreign key relationship between the two joined tables.
public final J
onKey(TableField<?, ?>... keyFields)

Implements org.jooq.TableOnStep.onKey.

Deprecated as a consequence of TableField being deprecated.
Join the table on a non-ambiguous foreign key relationship between the two joined tables.
public final J
onKey(ForeignKey<?, ?> key)

Implements org.jooq.TableOnStep.onKey.

Join the table on a non-ambiguous foreign key relationship between the two joined tables.
private final J
onKey(ForeignKey<?, ?> key, Table<?> fk, Table<?> pk)

pack-priv static final Condition
onKey0(ForeignKey<?, ?> key, Table<?> fk, Table<?> pk)

Deprecated as a consequence of Condition being deprecated.
private final DataAccessException
onKeyException(JoinTable.OnKeyExceptionReason reason, List<?> leftToRight, List<?> rightToLeft)

public final J
or(Condition c)

Implements org.jooq.TableOnConditionStep.or.

Deprecated as a consequence of Condition being deprecated.
Combine the currently assembled conditions with another one using the Operator#OR operator.
public final J
or(Field<Boolean> c)

Implements org.jooq.TableOnConditionStep.or.

Deprecated as a consequence of Field being deprecated.
Combine the currently assembled conditions with another one using the Operator#OR operator.
public final J
or(SQL sql)

Implements org.jooq.TableOnConditionStep.or.

Combine the currently assembled conditions with another one using the Operator#OR operator.
public final J
or(String sql)

Implements org.jooq.TableOnConditionStep.or.

Combine the currently assembled conditions with another one using the Operator#OR operator.
public final J
or(String sql, Object... bindings)

Implements org.jooq.TableOnConditionStep.or.

Combine the currently assembled conditions with another one using the Operator#OR operator.
public final J
or(String sql, QueryPart... parts)

Implements org.jooq.TableOnConditionStep.or.

Combine the currently assembled conditions with another one using the Operator#OR operator.
public final J
orExists(Select<?> select)

Implements org.jooq.TableOnConditionStep.orExists.

Combine the currently assembled conditions with an EXISTS clause using the Operator#OR operator.
public final J
orNot(Condition c)

Implements org.jooq.TableOnConditionStep.orNot.

Deprecated as a consequence of Condition being deprecated.
Combine the currently assembled conditions with a negated other one using the Operator#OR operator.
public final J
orNot(Field<Boolean> c)

Implements org.jooq.TableOnConditionStep.orNot.

Deprecated as a consequence of Field being deprecated.
Combine the currently assembled conditions with a negated other one using the Operator#OR operator.
public final J
orNotExists(Select<?> select)

Implements org.jooq.TableOnConditionStep.orNotExists.

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator#OR operator.
pack-priv final J
partitionBy0(Collection<? extends Field<?>> fields)

private final void
toSQLJoinCondition(Context<?> ctx)

private final void
toSQLJoinCondition(Context<?> context, Condition c)

Deprecated as a consequence of Condition being deprecated.
private void
toSQLTable(Context<?> ctx, Table<?> table)

pack-priv final J
transform(Table<?> newLhs, Table<?> newRhs)

Deprecated
pack-priv final Clause
translateClause(JoinType translatedType)

Deprecated as a consequence of Clause being deprecated.
Translate the join type into a join clause
private final Keyword
translateKeyword(Context<?> ctx, JoinType translatedType)

pack-priv final JoinType
translateType(Context<?> ctx)

Translate the join type for SQL rendering

public final J
using(Field<?>... fields)

Implements org.jooq.TableOnStep.using.

Deprecated as a consequence of Field being deprecated.
Join a table with the USING(column [, column…]) syntax.
public final J
using(Collection<? extends Field<?>> fields)

Implements org.jooq.TableOnStep.using.

Join a table with the USING(column [, column…]) syntax.
pack-priv final Condition
usingCondition()

Deprecated as a consequence of Condition being deprecated.
Inherited from org.jooq.impl.AbstractTable:
$alias$aliased$dataType$schemaasasasasasasasasasasasasasasasMultisetasMultisetasMultisetasMultisetasTableasTableasTableasTableasTableasTableasTableasTableasTableasTableasTableasTableasteriskconvertconvertconvertconvertFromconvertFromconvertToconvertTocreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateField0createField0createField0createField0crossApplycrossApplycrossApplycrossApplycrossApplycrossApplycrossJoincrossJoincrossJoincrossJoincrossJoincrossJoindivideByeqequalfieldsfieldsRowforceIndexforceIndexForGroupByforceIndexForJoinforceIndexForOrderByfromfullJoinfullJoinfullJoinfullJoinfullJoinfullJoinfullOuterJoinfullOuterJoinfullOuterJoinfullOuterJoinfullOuterJoinfullOuterJoingetBindinggetCataloggetChecksgetConvertergetDataTypegetDataTypegetIdentitygetIndexesgetKeysgetOptionsgetPackagegetPrimaryKeygetRecordTimestampgetRecordVersiongetReferencesFromgetReferencesTogetSchemagetTableTypegetTypegetUniqueKeysignoreIndexignoreIndexForGroupByignoreIndexForJoinignoreIndexForOrderByinnerJoininnerJoininnerJoininnerJoininnerJoininnerJoinjoinjoinjoinjoinjoinjoinleftAntiJoinleftJoinleftJoinleftJoinleftJoinleftJoinleftJoinleftOuterJoinleftOuterJoinleftOuterJoinleftOuterJoinleftOuterJoinleftOuterJoinleftSemiJoinnaturalFullOuterJoinnaturalFullOuterJoinnaturalFullOuterJoinnaturalFullOuterJoinnaturalFullOuterJoinnaturalFullOuterJoinnaturalJoinnaturalJoinnaturalJoinnaturalJoinnaturalJoinnaturalJoinnaturalLeftOuterJoinnaturalLeftOuterJoinnaturalLeftOuterJoinnaturalLeftOuterJoinnaturalLeftOuterJoinnaturalLeftOuterJoinnaturalRightOuterJoinnaturalRightOuterJoinnaturalRightOuterJoinnaturalRightOuterJoinnaturalRightOuterJoinnaturalRightOuterJoinnenewRecordnotEqualouterApplyouterApplyouterApplyouterApplyouterApplyouterApplyrecordTyperightJoinrightJoinrightJoinrightJoinrightJoinrightJoinrightOuterJoinrightOuterJoinrightOuterJoinrightOuterJoinrightOuterJoinrightOuterJoinrowidstraightJoinstraightJoinstraightJoinstraightJoinstraightJoinstraightJointfuseIndexuseIndexForGroupByuseIndexForJoinuseIndexForOrderBywherewherewherewherewherewherewherewherewhereExistswhereNotExistswithOrdinality