com.hfg.sql

Class SQLJoinType

java.lang.Object

com.hfg.sql.SQLJoinType

public class SQLJoinType
extends Object

Standard SQL join types.

Field Summary

Fields

Modifier and Type	Field and Description
static SQLJoinType	CROSS_JOIN Cartesian product (every possible combination) of rows from TABLE1 and TABLE2.
static SQLJoinType	FULL_OUTER_JOIN
static SQLJoinType	INNER_JOIN
static SQLJoinType	JOIN
static SQLJoinType	LEFT_OUTER_JOIN
static SQLJoinType	NATURAL_JOIN
static SQLJoinType	RIGHT_OUTER_JOIN

Method Summary

Modifier and Type	Method and Description
int	compareTo(Object inObj2)
boolean	equals(Object inObj2)
int	hashCode()
String	name()
String	toString()
SQLJoinType	valueOf(String inString)
SQLJoinType[]	values()

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Field Detail

JOIN

public static final SQLJoinType JOIN

CROSS_JOIN

public static final SQLJoinType CROSS_JOIN

Cartesian product (every possible combination) of rows from TABLE1 and TABLE2. The joined table will contain a row consisting of all columns in TABLE1 followed by all columns in TABLE2. If the tables have N and M rows respectively, the joined table will have N * M rows.

INNER_JOIN

public static final SQLJoinType INNER_JOIN

LEFT_OUTER_JOIN

public static final SQLJoinType LEFT_OUTER_JOIN

RIGHT_OUTER_JOIN

public static final SQLJoinType RIGHT_OUTER_JOIN

FULL_OUTER_JOIN

public static final SQLJoinType FULL_OUTER_JOIN

NATURAL_JOIN

public static final SQLJoinType NATURAL_JOIN

Method Detail

values

public SQLJoinType[] values()

valueOf

public SQLJoinType valueOf(String inString)

equals

public boolean equals(Object inObj2)

Overrides:

equals in class Object

hashCode

public int hashCode()

Overrides:

hashCode in class Object

compareTo

public int compareTo(Object inObj2)

toString

public String toString()

Overrides:

toString in class Object

name

public String name()