Top Description Fields Constructors Methods

org.jooq

public final Enum JoinType

Class Inheritance

extends Enum<JoinType>

Static Imports

org.jooq.SQLDialect.CUBRID, .SQLDialect.DERBY, .SQLDialect.FIREBIRD, .SQLDialect.H2, .SQLDialect.HSQLDB, .SQLDialect.IGNITE, .SQLDialect.MARIADB, .SQLDialect.MYSQL, .SQLDialect.POSTGRES, .SQLDialect.SQLITE, .SQLDialect.YUGABYTEDB

The type of join.

Author: Lukas Eder

Field Summary

Modifier and Type	Field and Description
public static final JoinType	CROSS_APPLY `CROSS APPLY` two tables.
public static final JoinType	CROSS_JOIN `CROSS JOIN` two tables.
private final Keyword	defaultKeyword
private final String	defaultSql
private final Keyword	excludingOptionalKeywords
public static final JoinType	FULL_OUTER_JOIN `FULL OUTER JOIN` two tables.
private final Keyword	includingOptionalKeywords
public static final JoinType	JOIN `INNER JOIN` two tables.
public static final JoinType	LEFT_ANTI_JOIN `LEFT ANTI JOIN` two tables.
public static final JoinType	LEFT_OUTER_JOIN `LEFT OUTER JOIN` two tables.
public static final JoinType	LEFT_SEMI_JOIN `LEFT SEMI JOIN` two tables.
public static final JoinType	NATURAL_FULL_OUTER_JOIN `NATURAL FULL OUTER JOIN` two tables.
public static final JoinType	NATURAL_JOIN `NATURAL INNER JOIN` two tables.
public static final JoinType	NATURAL_LEFT_OUTER_JOIN `NATURAL LEFT OUTER JOIN` two tables.
public static final JoinType	NATURAL_RIGHT_OUTER_JOIN `NATURAL RIGHT OUTER JOIN` two tables.
public static final JoinType	OUTER_APPLY `OUTER APPLY` two tables.
private final boolean	qualified
public static final JoinType	RIGHT_OUTER_JOIN `RIGHT OUTER JOIN` two tables.
public static final JoinType	STRAIGHT_JOIN `STRAIGHT_JOIN` two tables.

Constructor Summary

Access	Constructor and Description
private	JoinType(String sql, boolean qualified)
private	JoinType(String defaultSql, String includingOptionalKeywords, String excludingOptionalKeywords, boolean qualified)

Method Summary

Modifier and Type	Method and Description
public final boolean	qualified() Whether a `JOIN` operation of this type must be qualified with `ON` or `USING`.
public final Keyword	toKeyword()
public final Keyword	toKeyword(boolean includeOptionalKeywords)
public final String	toSQL()
public static JoinType	valueOf(String name)
public static JoinType[]	values()

Inherited from java.lang.Enum:: clone compareTo describeConstable equals finalize getDeclaringClass hashCode name ordinal toString valueOf

Field Detail

CROSS_APPLY	back to summary
public static final JoinType CROSS_APPLY `CROSS APPLY` two tables. Annotations @NotNull @Support:FIREBIRD, POSTGRES, YUGABYTEDB

CROSS_JOIN	back to summary
public static final JoinType CROSS_JOIN `CROSS JOIN` two tables. Annotations @NotNull @Support

defaultKeyword	back to summary
private final Keyword defaultKeyword

defaultSql	back to summary
private final String defaultSql

excludingOptionalKeywords	back to summary
private final Keyword excludingOptionalKeywords

FULL_OUTER_JOIN	back to summary
public static final JoinType FULL_OUTER_JOIN `FULL OUTER JOIN` two tables. Annotations @NotNull @Support:FIREBIRD, HSQLDB, POSTGRES, SQLITE, YUGABYTEDB

includingOptionalKeywords	back to summary
private final Keyword includingOptionalKeywords

JOIN	back to summary
public static final JoinType JOIN `INNER JOIN` two tables. Annotations @NotNull @Support

LEFT_ANTI_JOIN	back to summary
public static final JoinType LEFT_ANTI_JOIN `LEFT ANTI JOIN` two tables. Annotations @NotNull @Support

LEFT_OUTER_JOIN	back to summary
public static final JoinType LEFT_OUTER_JOIN `LEFT OUTER JOIN` two tables. Annotations @NotNull @Support

LEFT_SEMI_JOIN	back to summary
public static final JoinType LEFT_SEMI_JOIN `LEFT SEMI JOIN` two tables. Annotations @NotNull @Support

NATURAL_FULL_OUTER_JOIN	back to summary
public static final JoinType NATURAL_FULL_OUTER_JOIN `NATURAL FULL OUTER JOIN` two tables. Annotations @NotNull @Support:FIREBIRD, HSQLDB, POSTGRES, SQLITE, YUGABYTEDB

NATURAL_JOIN	back to summary
public static final JoinType NATURAL_JOIN `NATURAL INNER JOIN` two tables. Annotations @NotNull @Support

NATURAL_LEFT_OUTER_JOIN	back to summary
public static final JoinType NATURAL_LEFT_OUTER_JOIN `NATURAL LEFT OUTER JOIN` two tables. Annotations @NotNull @Support

NATURAL_RIGHT_OUTER_JOIN	back to summary
public static final JoinType NATURAL_RIGHT_OUTER_JOIN `NATURAL RIGHT OUTER JOIN` two tables. Annotations @NotNull @Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

OUTER_APPLY	back to summary
public static final JoinType OUTER_APPLY `OUTER APPLY` two tables. Annotations @NotNull @Support:FIREBIRD, POSTGRES, YUGABYTEDB

qualified	back to summary
private final boolean qualified

RIGHT_OUTER_JOIN	back to summary
public static final JoinType RIGHT_OUTER_JOIN `RIGHT OUTER JOIN` two tables. Annotations @NotNull @Support

STRAIGHT_JOIN	back to summary
public static final JoinType STRAIGHT_JOIN `STRAIGHT_JOIN` two tables. Annotations @NotNull @Support:MARIADB, MYSQL

Constructor Detail

JoinType	back to summary
private JoinType(String sql, boolean qualified)

JoinType	back to summary
private JoinType(String defaultSql, String includingOptionalKeywords, String excludingOptionalKeywords, boolean qualified)

Method Detail

qualified	back to summary
public final boolean qualified() Whether a `JOIN` operation of this type must be qualified with `ON` or `USING`.

toKeyword	back to summary
public final Keyword toKeyword()

toKeyword	back to summary
public final Keyword toKeyword(boolean includeOptionalKeywords)

toSQL	back to summary
public final String toSQL()

valueOf	back to summary
public static JoinType valueOf(String name)

values	back to summary
public static JoinType[] values()