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