JoinType (jOOQ 3.8.1 API)

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 and 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_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 and Description
`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
public static final JoinType RIGHT_OUTER_JOIN
```
    RIGHT OUTER JOIN two tables.
  - FULL_OUTER_JOIN
```
@Support
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
public static final JoinType NATURAL_RIGHT_OUTER_JOIN
```
    NATURAL RIGHT OUTER JOIN two tables.
  - CROSS_APPLY
```
@Support(value={ORACLE12C,SQLSERVER,SYBASE})
public static final JoinType CROSS_APPLY
```
    CROSS APPLY two tables.
  - OUTER_APPLY
```
@Support(value={ORACLE12C,SQLSERVER,SYBASE})
public static final JoinType OUTER_APPLY
```
    OUTER APPLY two tables.
  - STRAIGHT_JOIN
```
@Support(value=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()
```

Enum JoinType

Enum Constant Summary

Method Summary

Methods inherited from class java.lang.Enum

Methods inherited from class java.lang.Object

Enum Constant Detail

JOIN

CROSS_JOIN

LEFT_OUTER_JOIN

RIGHT_OUTER_JOIN

FULL_OUTER_JOIN

NATURAL_JOIN

NATURAL_LEFT_OUTER_JOIN

NATURAL_RIGHT_OUTER_JOIN

CROSS_APPLY

OUTER_APPLY

STRAIGHT_JOIN

LEFT_SEMI_JOIN

LEFT_ANTI_JOIN

Method Detail

values

valueOf

toSQL