org.exolab.castor.jdo.drivers
Class SybaseQueryExpression
- QueryExpression
public final class SybaseQueryExpression
QueryExpression for Sybase Adaptive Servers.
$Revision: 7123 $ $Date: 2004-10-01 07:25:46 -0600 (Fri, 01 Oct 2004) $
void | addInnerJoin(String leftTable, String leftColumn, String leftTableAlias, String rightTable, String rightColumn, String rightTableAlias)- Add an inner join with an aliases for the tables.
|
String | getStatement(boolean lock)- Creates a SQL statement.
|
addColumn, addCondition, addInnerJoin, addInnerJoin, addInnerJoin, addInnerJoin, addLimitClause, addOffsetClause, addOrderClause, addOuterJoin, addOuterJoin, addOuterJoin, addOuterJoin, addParameter, addSelect, addTable, addTable, addWhereClause, addWhereClause, clone, encodeColumn, getColumnList, getStandardStatement, getStatement, isLimitClauseSupported, isOffsetClauseSupported, setDbMetaInfo, setDistinct, toString |
addInnerJoin
public void addInnerJoin(String leftTable,
String leftColumn,
String leftTableAlias,
String rightTable,
String rightColumn,
String rightTableAlias) Add an inner join with an aliases for the tables.
- addInnerJoin in interface QueryExpression
- addInnerJoin in interface JDBCQueryExpression
leftTable - The table name on the left side.leftColumn - The column name on the left side.leftTableAlias - The alias name to use for the table on the left side.rightTable - The table name on the right side.rightColumn - The column name on the right side.rightTableAlias - The alias name to use for the table on the right side.
getStatement
public String getStatement(boolean lock)
Creates a SQL statement.
In general, for a RDBMS/JDBC driver with a full support of the SQL standard/JDBC
specification, this will return a valid SQL statement. For some features,
a particular RDBMS might indicate that it does not support this feature by
throwing a
SyntaxNotSupportedException.
- getStatement in interface QueryExpression
- getStatement in interface JDBCQueryExpression
Intalio Inc. (C) 1999-2008. All rights reserved http://www.intalio.com