Module org.jooq

Package org.jooq

Enum Class JoinType

java.lang.Object

java.lang.Enum<JoinType>

org.jooq.JoinType

All Implemented Interfaces:

Serializable, Comparable<JoinType>, Constable

public enum JoinType
extends Enum<JoinType>

The type of join.

Author:

Lukas Eder

Nested Class Summary

Nested classes/interfaces inherited from class java.lang.Enum

Enum.EnumDesc<E extends Enum<E>>

Enum Constant Summary

Enum Constants

Enum Constant	Description
CROSS_APPLY	CROSS APPLY two tables.
CROSS_JOIN	CROSS JOIN two tables.
FULL_OUTER_JOIN	FULL OUTER JOIN two tables.
JOIN	INNER JOIN two tables.
LEFT_ANTI_JOIN	LEFT ANTI JOIN two tables.
LEFT_OUTER_JOIN	LEFT OUTER JOIN two tables.
LEFT_SEMI_JOIN	LEFT SEMI JOIN two tables.
NATURAL_FULL_OUTER_JOIN	NATURAL FULL OUTER JOIN two tables.
NATURAL_JOIN	NATURAL INNER JOIN two tables.
NATURAL_LEFT_OUTER_JOIN	NATURAL LEFT OUTER JOIN two tables.
NATURAL_RIGHT_OUTER_JOIN	NATURAL RIGHT OUTER JOIN two tables.
OUTER_APPLY	OUTER APPLY two tables.
RIGHT_OUTER_JOIN	RIGHT OUTER JOIN two tables.
STRAIGHT_JOIN	STRAIGHT_JOIN two tables.

Method Summary

Modifier and Type	Method	Description
final boolean	correlated()	Whether a JOIN operation of this type can be correlated.
final boolean	qualified()	Whether a JOIN operation of this type must be qualified with ON or USING.
final Keyword	toKeyword()
final Keyword	toKeyword(boolean includeOptionalKeywords)
final String	toSQL()
static JoinType	valueOf(String name)	Returns the enum constant of this class with the specified name.
static JoinType[]	values()	Returns an array containing the constants of this enum class, in the order they are declared.

Methods inherited from class java.lang.Enum

clone, compareTo, describeConstable, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Details

JOIN

@NotNull
@Support
public static final JoinType JOIN

INNER JOIN two tables.

CROSS_JOIN

@NotNull
@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DATABRICKS,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB})
public static final JoinType CROSS_JOIN

CROSS JOIN two tables.

LEFT_OUTER_JOIN

@NotNull
@Support
public static final JoinType LEFT_OUTER_JOIN

LEFT OUTER JOIN two tables.

RIGHT_OUTER_JOIN

@NotNull
@Support
public static final JoinType RIGHT_OUTER_JOIN

RIGHT OUTER JOIN two tables.

FULL_OUTER_JOIN

@NotNull
@Support({AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,DATABRICKS,DB2,EXASOL,FIREBIRD,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE_3_39,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB})
public static final JoinType FULL_OUTER_JOIN

FULL OUTER JOIN two tables.

NATURAL_JOIN

@NotNull
@Support
public static final JoinType NATURAL_JOIN

NATURAL INNER JOIN two tables.

NATURAL_LEFT_OUTER_JOIN

@NotNull
@Support
public static final JoinType NATURAL_LEFT_OUTER_JOIN

NATURAL LEFT OUTER JOIN two tables.

NATURAL_RIGHT_OUTER_JOIN

@NotNull
@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DATABRICKS,DB2,DERBY,EXASOL,FIREBIRD,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE_3_39,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB})
public static final JoinType NATURAL_RIGHT_OUTER_JOIN

NATURAL RIGHT OUTER JOIN two tables.

NATURAL_FULL_OUTER_JOIN

@NotNull
@Support({AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,DATABRICKS,DB2,EXASOL,FIREBIRD,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE_3_39,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB})
public static final JoinType NATURAL_FULL_OUTER_JOIN

NATURAL FULL OUTER JOIN two tables.

CROSS_APPLY

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,DATABRICKS,DB2,FIREBIRD_4_0,HANA,ORACLE12C,POSTGRES_9_3,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TRINO,YUGABYTEDB})
public static final JoinType CROSS_APPLY

CROSS APPLY two tables.

OUTER_APPLY

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,DATABRICKS,DB2,FIREBIRD_4_0,HANA,ORACLE12C,POSTGRES_9_3,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TRINO,YUGABYTEDB})
public static final JoinType OUTER_APPLY

OUTER APPLY two tables.

STRAIGHT_JOIN

@NotNull
@Support({AURORA_MYSQL,MARIADB,MEMSQL,MYSQL})
public static final JoinType STRAIGHT_JOIN

STRAIGHT_JOIN two tables.

LEFT_SEMI_JOIN

@NotNull
@Support
public static final JoinType LEFT_SEMI_JOIN

LEFT SEMI JOIN two tables.

LEFT_ANTI_JOIN

@NotNull
@Support
public static final JoinType LEFT_ANTI_JOIN

LEFT ANTI JOIN two tables.

Method Details

values

public static JoinType[] values()

Returns an array containing the constants of this enum class, in the order they are declared.

Returns:

an array containing the constants of this enum class, in the order they are declared

valueOf

public static JoinType valueOf(String name)

Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (Extraneous whitespace characters are not permitted.)

Parameters:

name - the name of the enum constant to be returned.

Returns:

the enum constant with the specified name

Throws:

IllegalArgumentException - if this enum class has no constant with the specified name

NullPointerException - if the argument is null

toSQL

public final String toSQL()

toKeyword

public final Keyword toKeyword()

toKeyword

public final Keyword toKeyword(boolean includeOptionalKeywords)

qualified

public final boolean qualified()

Whether a JOIN operation of this type must be qualified with ON or USING.

correlated

public final boolean correlated()

Whether a JOIN operation of this type can be correlated.