org.apache.ojb.broker.accesslayer
Interface JoinSyntaxTypes

All Known Implementing Classes:

PlatformDb2Impl, PlatformDefaultImpl, PlatformDerbyImpl, PlatformFirebirdImpl, PlatformHsqldbImpl, PlatformInformixImpl, PlatformMaxDBImpl, PlatformMsAccessImpl, PlatformMsSQLServerImpl, PlatformMySQLImpl, PlatformOracle9iImpl, PlatformOracleImpl, PlatformPostgreSQLImpl, PlatformSapdbImpl, PlatformSybaseASAImpl, PlatformSybaseASEImpl, PlatformSybaseImpl, PlatformWLOracle9iImpl, SqlDeleteByQuery, SqlQueryStatement, SqlSelectByPkStatement, SqlSelectStatement

public interface JoinSyntaxTypes

Constants used to denote the type of SQL syntax of JOINs

Version:

$Id: JoinSyntaxTypes.java,v 1.1 2007-08-24 22:17:30 ewestfal 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

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

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

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

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