Module org.jooq

Package org.jooq

Enum JoinType

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

Modifier and Type	Method	Description
boolean	qualified()	Whether a JOIN operation of this type must be qualified with ON or USING.
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.

Methods inherited from class java.lang.Enum

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

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Detail

JOIN

@Support
public static final JoinType JOIN

INNER JOIN two tables.

CROSS_JOIN

@Support
public static final JoinType CROSS_JOIN

CROSS JOIN two tables.

LEFT_OUTER_JOIN

@Support
public static final JoinType LEFT_OUTER_JOIN

LEFT OUTER JOIN two tables.

RIGHT_OUTER_JOIN

@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

@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

@Support
public static final JoinType NATURAL_JOIN

NATURAL INNER JOIN two tables.

NATURAL_LEFT_OUTER_JOIN

@Support
public static final JoinType NATURAL_LEFT_OUTER_JOIN

NATURAL LEFT OUTER JOIN two tables.

NATURAL_RIGHT_OUTER_JOIN

@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

@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

@Support({AURORA_POSTGRES,DB2,ORACLE12C,POSTGRES_9_3,SQLDATAWAREHOUSE,SQLSERVER,SYBASE})
public static final JoinType CROSS_APPLY

CROSS APPLY two tables.

OUTER_APPLY

@Support({AURORA_POSTGRES,DB2,ORACLE12C,POSTGRES_9_3,SQLDATAWAREHOUSE,SQLSERVER,SYBASE})
public static final JoinType OUTER_APPLY

OUTER APPLY two tables.

STRAIGHT_JOIN

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

STRAIGHT_JOIN two tables.

LEFT_SEMI_JOIN

@Support
public static final JoinType LEFT_SEMI_JOIN

LEFT SEMI JOIN two tables.

LEFT_ANTI_JOIN

@Support
public static final JoinType LEFT_ANTI_JOIN

LEFT ANTI 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 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.