- All Implemented Interfaces:
Serializable
,Comparable<JoinType>
,Constable
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 ConstantDescriptionCROSS APPLY
two tables.CROSS JOIN
two tables.FULL OUTER JOIN
two tables.INNER JOIN
two tables.LEFT ANTI JOIN
two tables.LEFT OUTER JOIN
two tables.LEFT SEMI JOIN
two tables.NATURAL FULL OUTER JOIN
two tables.NATURAL INNER JOIN
two tables.NATURAL LEFT OUTER JOIN
two tables.NATURAL RIGHT OUTER JOIN
two tables.OUTER APPLY
two tables.RIGHT OUTER JOIN
two tables.STRAIGHT_JOIN
two tables. -
Method Summary
Modifier and TypeMethodDescriptionfinal boolean
Whether aJOIN
operation of this type must be qualified withON
orUSING
.final Keyword
final Keyword
toKeyword
(boolean includeOptionalKeywords) final String
toSQL()
static JoinType
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.
-
Enum Constant Details
-
JOIN
INNER JOIN
two tables. -
CROSS_JOIN
@NotNull @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) public static final JoinType CROSS_JOINCROSS JOIN
two tables. -
LEFT_OUTER_JOIN
LEFT OUTER JOIN
two tables. -
RIGHT_OUTER_JOIN
@NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) public static final JoinType RIGHT_OUTER_JOINRIGHT OUTER JOIN
two tables. -
FULL_OUTER_JOIN
@NotNull @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) public static final JoinType FULL_OUTER_JOINFULL 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
@NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) public static final JoinType NATURAL_RIGHT_OUTER_JOINNATURAL RIGHT OUTER JOIN
two tables. -
NATURAL_FULL_OUTER_JOIN
@NotNull @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) public static final JoinType NATURAL_FULL_OUTER_JOINNATURAL FULL OUTER JOIN
two tables. -
CROSS_APPLY
@NotNull @Support({AURORA_POSTGRES,BIGQUERY,DB2,FIREBIRD_4_0,ORACLE12C,POSTGRES_9_3,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,YUGABYTEDB}) public static final JoinType CROSS_APPLYCROSS APPLY
two tables. -
OUTER_APPLY
@NotNull @Support({AURORA_POSTGRES,BIGQUERY,DB2,FIREBIRD_4_0,ORACLE12C,POSTGRES_9_3,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,YUGABYTEDB}) public static final JoinType OUTER_APPLYOUTER APPLY
two tables. -
STRAIGHT_JOIN
STRAIGHT_JOIN
two tables. -
LEFT_SEMI_JOIN
LEFT SEMI JOIN
two tables. -
LEFT_ANTI_JOIN
LEFT ANTI JOIN
two tables.
-
-
Method Details
-
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
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 nameNullPointerException
- if the argument is null
-
toSQL
-
toKeyword
-
toKeyword
-
qualified
public final boolean qualified()Whether aJOIN
operation of this type must be qualified withON
orUSING
.
-