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

public interface JoinSyntaxTypes

Constants used to denote the type of SQL syntax of JOINs

Version:
$Id: JoinSyntaxTypes.java 365232 2005-12-21 22:36:07Z tomdz $
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


(C) 2002 - 2006 Apache Software Foundation
All rights reserved. Published under the Apache License 2.0.
http://db.apache.org/ojb
Version: 1.0.4, 2005-12-30