- java.lang.Object
-
- java.lang.Enum<JoinType>
-
- org.jooq.JoinType
-
- All Implemented Interfaces:
Serializable
,Comparable<JoinType>
public enum JoinType extends Enum<JoinType>
The type of join.- Author:
- Lukas Eder
-
-
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
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method Description boolean
qualified()
Whether aJOIN
operation of this type must be qualified withON
orUSING
.Keyword
toKeyword()
Keyword
toKeyword(boolean includeOptionalKeywords)
String
toSQL()
static JoinType
valueOf(String name)
Returns the enum constant of this type with the specified name.static JoinType[]
values()
Returns an array containing the constants of this enum type, in the order they are declared.
-
-
-
Enum Constant Detail
-
LEFT_OUTER_JOIN
@NotNull @Support public static final JoinType LEFT_OUTER_JOIN
LEFT OUTER JOIN
two tables.
-
RIGHT_OUTER_JOIN
@NotNull @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) public static final JoinType RIGHT_OUTER_JOIN
RIGHT OUTER JOIN
two tables.
-
FULL_OUTER_JOIN
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) 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,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) public static final JoinType NATURAL_RIGHT_OUTER_JOIN
NATURAL RIGHT OUTER JOIN
two tables.
-
NATURAL_FULL_OUTER_JOIN
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) public static final JoinType NATURAL_FULL_OUTER_JOIN
NATURAL FULL OUTER JOIN
two tables.
-
CROSS_APPLY
@NotNull @Support({AURORA_POSTGRES,DB2,ORACLE12C,POSTGRES_9_3,SQLDATAWAREHOUSE,SQLSERVER,SYBASE}) public static final JoinType CROSS_APPLY
CROSS APPLY
two tables.
-
OUTER_APPLY
@NotNull @Support({AURORA_POSTGRES,DB2,ORACLE12C,POSTGRES_9_3,SQLDATAWAREHOUSE,SQLSERVER,SYBASE}) 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.
-
-
Method Detail
-
values
public static JoinType[] values()
Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:for (JoinType c : JoinType.values()) System.out.println(c);
- Returns:
- an array containing the constants of this enum type, in the order they are declared
-
valueOf
public static JoinType valueOf(String name)
Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (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 type has no constant with the specified nameNullPointerException
- 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 aJOIN
operation of this type must be qualified withON
orUSING
.
-
-