| org.apache.ojb.broker.accesslayer.JoinSyntaxTypes
All known Subclasses: org.apache.ojb.broker.platforms.PlatformDefaultImpl, org.apache.ojb.broker.accesslayer.sql.SqlQueryStatement,
JoinSyntaxTypes | public interface JoinSyntaxTypes (Code) | | Constants used to denote the type of SQL syntax of JOINs
author: Oleg Nitz version: $Id: JoinSyntaxTypes.java,v 1.4.2.1 2005/12/21 22:22:58 tomdz Exp $ |
ORACLE_JOIN_SYNTAX | final public byte ORACLE_JOIN_SYNTAX(Code) | | Oracle syntax for joins:
SELECT ... FROM A, B WHERE A.PK=B.FK
SELECT ... FROM A, B WHERE A.PK=B.FK(+)
|
SQL92_JOIN_SYNTAX | final public byte SQL92_JOIN_SYNTAX(Code) | | 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
|
SQL92_NOPAREN_JOIN_SYNTAX | final public byte SQL92_NOPAREN_JOIN_SYNTAX(Code) | | 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
|
SYBASE_JOIN_SYNTAX | final public byte SYBASE_JOIN_SYNTAX(Code) | | Sybase ASE syntax for joins:
SELECT ... FROM A, B WHERE A.PK=B.FK
SELECT ... FROM A, B WHERE A.PK*=B.FK
|
|
|