org.apache.ojb.broker.accesslayer
Interface JoinSyntaxTypes

All Known Implementing Classes:

PlatformDefaultImpl, SqlQueryStatement

public interface JoinSyntaxTypes

Constants used to denote the type of SQL syntax of JOINs

Version:

$Id: JoinSyntaxTypes.java,v 1.2 2002/06/17 19:34:06 jvanzyl Exp $

Author:

Oleg Nitz

Field Summary

static byte	ORACLE_JOIN_SYNTAX Oracle syntax for joins: SELECT ...
static byte	SQL92_JOIN_SYNTAX SQL-92 syntax for joins: SELECT ...
static byte	SQL92_NOPAREN_JOIN_SYNTAX SQL-92 without parenthesis syntax for joins: SELECT ...
static byte	SYBASE_JOIN_SYNTAX Sybase ASE syntax for joins: SELECT ...

Field Detail

SQL92_JOIN_SYNTAX

public static final byte SQL92_JOIN_SYNTAX

SQL-92 syntax for joins:
SELECT ... FROM A INNER JOIN B ON A.PK=B.FK
SELECT ... FROM A LEFT OUTER JOIN B ON A.PK=B.FK
Nested joins:
SELECT ... FROM A INNER JOIN (B INNER JOIN C ON B.PK=C.FK) ON A.PK=B.FK
SELECT ... FROM A LEFT OUTER JOIN (B LEFT OUTER JOIN C ON B.PK=C.FK) ON A.PK=B.FK

See Also:

Constant Field Values

SQL92_NOPAREN_JOIN_SYNTAX

public static final byte SQL92_NOPAREN_JOIN_SYNTAX

SQL-92 without parenthesis syntax for joins:
SELECT ... FROM A INNER JOIN B ON A.PK=B.FK
SELECT ... FROM A LEFT OUTER JOIN B ON A.PK=B.FK
Nested joins:
SELECT ... FROM A INNER JOIN ON A.PK=B.FK INNER JOIN C ON B.PK=C.FK
SELECT ... FROM A LEFT OUTER JOIN ON A.PK=B.FK LEFT OUTER JOIN C ON B.PK=C.FK

See Also:

Constant Field Values

ORACLE_JOIN_SYNTAX

public static final byte ORACLE_JOIN_SYNTAX

Oracle syntax for joins:
SELECT ... FROM A, B WHERE A.PK=B.FK
SELECT ... FROM A, B WHERE A.PK=B.FK(+)

See Also:

Constant Field Values

SYBASE_JOIN_SYNTAX

public static final byte SYBASE_JOIN_SYNTAX

Sybase ASE syntax for joins:
SELECT ... FROM A, B WHERE A.PK=B.FK
SELECT ... FROM A, B WHERE A.PK*=B.FK

See Also:

Constant Field Values