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
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 - 2005 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